SSRS Summery data export issue

 

The user has requested to include the summary record in the report but to exclude the additional columns that have been appended to the data records. The other limitation they have imposed is that no other textboxes appear in the .csv file export. They only want to see the detail records with one header record at the top. The report needs to be exported as a .csv file because it exceeds the number of records which Excel can handle.

So far my research has reminded me that exporting a .csv file from SSRS exports only the data and strips out all formatting, therefore, the summary data is associated with each data record.

Here is the solution for this.

For each data element you want to exclude:

1. Open the properties menu for the TextBox with F4

2. Set the DataElementOutput property to NoOutput

   

 

SRS 2008 report which has 3 column groups which when i export to Excel the resulting excel spreadsheet has an additional total column for each of the groups.  I dont have this displayed in the report and dont want it displayed in teh excel export, is there anyway to turn this off?

SSRS 2008 report which has 3 column groups which when i export to Excel the resulting excel spreadsheet has an additional total column for each of the groups.Below is the trick for overcome this issue.

If you are running SSRS 2008 R2, you can set the total columns / cells ' visibility to =(Globals!RenderFormat.Name ="Excel") to hide them when exporting to Excel.

Following url has more in formation about rendering formats.

http://blogs.msdn.com/b/robertbruckner/archive/2010/05/02/globals-renderformat-aka-renderer-dependent-report-layout.aspx