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 …



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



<Extension Name="CSV (No Header)" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering">
   <Name Language="en-us">CSV No Header</Name>


Next restart the Reporting Service again and test it …

Connect to the Web Server to see the result.



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



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.


Enjoy !!

Leave a Reply

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

You are commenting using your 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: