SSRS – How to export a csv without header and more…

1. Create an New EXPORT Device using CSV without HEADERS

By default it exports the HEADER info as well …

image

 

Solution :

Go to the Reporting server config file.

C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\rsreportserver.config

Make a copy for backup reason and add this to the RENDER section

image

 

<Extension Name="CSV (No Header)" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering">
<OverrideNames>
   <Name Language="en-us">CSV No Header</Name>
</OverrideNames>
<Configuration>
   <DeviceInfo>
      <NoHeader>true</NoHeader>
      <FieldDelimiter>|</FieldDelimiter>
      <ExcelMode>False</ExcelMode>
   </DeviceInfo>
</Configuration>
</Extension>

 

Next restart the Reporting Service again and test it …

Connect to the Web Server to see the result.

image

 

2. Ever wanted to create a report where the EXPORT FIELDS would be different from the Report VIEW.

 

Solution :

Go to the field and set the Property DataElementOutput to NoOutput

 

image

This makes that these fields will NOT be EXPORTED  Smile

 

3. Print a label on the FOOTER page

 

Solution :

Select a label field you want to have printed on the last page only.

image

Enjoy !!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: