Post reply

Toggle Page Header

  • May 13, 2011 at 10:00 am

    #238211

    Hi, how can I toggle the page header in SSRS 2005 so that data analysts can avoid the graphics when they export to Excel files?

    Thanks in advance,

    Mark

  • May 13, 2011 at 10:22 am

    #1324451

    Export it to a .csv file instead.

  • May 16, 2011 at 2:32 am

    #1324897

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

    Mark

  • May 17, 2011 at 6:12 am

    #1325717

    You can use REPLACE to eliminate the commas within the field

    Replace(fielda,',',' ')

  • May 18, 2011 at 4:11 am

    #1326306

    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.

  • May 19, 2011 at 6:48 am

    #1327019

    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:

    http://blog.datainspirations.com/2010/03/03/sql-server-2008-r2-reporting-services-as-you-like-it/[/url]

    Rich

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

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