Toggle Page Header

Question

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 1

SSC-Dedicated

Points: 34566

May 13, 2011 at 10:22 am

Export it to a .csv file instead.

markzhe.ma SSC Rookie Points: 42 More actions · Answer 2

Thanks. But the data contain commers. Anyway, I do not have much choice.

Mark

charlene.hodges Grasshopper Points: 21 More actions · Answer 3

You can use REPLACE to eliminate the commas within the field

Replace(fielda,',',' ')

Dave Klug SSCertifiable Points: 5811 More actions · Answer 4

SSRS should wrap the fields in quotes prior to a CSV export. I have data with commas in it and never had an issue with CSV exports for these.

Rich Mechaber SSChampion Points: 11130 More actions · Answer 5

I haven't played with this, but it is supposed to be possible to inspect the report's render format and dynamically change the report.

Here's one link for you to get started:

Rich