Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
CODE PROJECT For Those Who Code
  • Home
  • Articles
  • FAQ
Community
  1. Home
  2. Database & SysAdmin
  3. Database
  4. SSRS 2008 Report - export to CSV

SSRS 2008 Report - export to CSV

Scheduled Pinned Locked Moved Database
databasesql-serverhelp
2 Posts 2 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • K Offline
    K Offline
    khandada
    wrote on last edited by
    #1

    I am using SSRS 2008 in my application. For some items the item description contain the data as "5X7" DISNEY POSTCARD" in database. When I do the export to csv file in SSRS 2008 the text displayed as "5X7 DISNEY POSTCARD"" in csv file, it is placing the double qoute at the end of the text instead where it should be. Please any one help me on this, I am running out of time. Thanks in advance -D

    M 1 Reply Last reply
    0
    • K khandada

      I am using SSRS 2008 in my application. For some items the item description contain the data as "5X7" DISNEY POSTCARD" in database. When I do the export to csv file in SSRS 2008 the text displayed as "5X7 DISNEY POSTCARD"" in csv file, it is placing the double qoute at the end of the text instead where it should be. Please any one help me on this, I am running out of time. Thanks in advance -D

      M Offline
      M Offline
      Mycroft Holmes
      wrote on last edited by
      #2

      You have a problem that is probably not solvable, CSV/Excel/MS converters use the " character as the text delimiter and probably wraps the entire text field in ". Embedded quotes are probably not going to be supported, certainly in CSV where it is a control character.

      Never underestimate the power of human stupidity RAH

      1 Reply Last reply
      0
      Reply
      • Reply as topic
      Log in to reply
      • Oldest to Newest
      • Newest to Oldest
      • Most Votes


      • Login

      • Don't have an account? Register

      • Login or register to search.
      • First post
        Last post
      0
      • Categories
      • Recent
      • Tags
      • Popular
      • World
      • Users
      • Groups