Archive

Posts Tagged ‘CSV’

SSRS : Disable CSV header while SSRS report export to CSV using URL Reporting

April 28, 2016 Leave a comment

Let say we have the report with only table and its deployed on server as shown below:-

CSVReport

Now export the report as CSV and open it ,  you will see the header columns as shown in below screen:-

CSVExported

Now create report-server URL as shown below:-

http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fSAMPLE%2fTest%2fCSVexportReport&rs:Command=Render&rc:NoHeader=True&rs:Format=CSV

Actually , you need to add the exiting reportserver URL with below line

&rc:NoHeader=True&rs:Format=CSV

Copy the above URL you just created and run on browser, it will ask open or save CSV file, once you open the file, there is no header.

NoHeader

 

 

So it working, if you like it please like the post below..

Thanks

Prasad

Learn Different BI Tools
Subscribe my YouTube Channel : Know BI Tools

Categories: Home, MSDN, SSRS Tags: , , ,