Toggle Page Header

• markzhe.ma

  SSC Rookie

  Points: 42

  More actions

  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

• Daniel Bowlin

  SSC-Dedicated

  Points: 34566

  More actions

  May 13, 2011 at 10:22 am

  #1324451

  Export it to a .csv file instead.

• markzhe.ma

  SSC Rookie

  Points: 42

  More actions

  May 16, 2011 at 2:32 am

  #1324897

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

  Mark

• charlene.hodges

  Grasshopper

  Points: 21

  More actions

  May 17, 2011 at 6:12 am

  #1325717

  You can use REPLACE to eliminate the commas within the field

  Replace(fielda,',',' ')

• Dave Klug

  SSCertifiable

  Points: 5811

  More actions

  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.

• Rich Mechaber

  SSChampion

  Points: 11130

  More actions

  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