Home » C++ ProgrammingRSS

CSV & pipe delimited export options - no header row

With the default .csv export and the added pipe delimited .txt version, they both include the field names as the 1st row.  I need to export to these file types only the data.

What needs to be done to create a export option that DOESN'T include the header row?

TIA,

Peedoe

 

5 Answers Found

 
 

Answer 2

Hi

There is no direct option  in SSRS for your requirement. For this you need to write custom Rendering Extensions. Following link will guide you.

http://msdn.microsoft.com/en-us/library/ms153624.aspx

http://vspug.com/kwanl/2007/05/03/writing-a-rendering-extension-for-reporting-services-2005/

http://msdn.microsoft.com/en-us/magazine/cc163840.aspx

Regards

 

Answer 3

Hi Peedoe,

In Summary point 7 is the direct answer to your question.

We don't have a huge amount of control over how the CSV renderer works within reporting services (without diving deep into RDL language). When I have a similar business requirement I; -

1) Get the underlying query of the data  source of the SSRS report,

2) create  an SSIS project

3) Create a data flow within the SSIS project.

4) Create an OLE DB connection manager within this data flow with similar details to the data source connection details of your SSRS report. 

5) Create a OLE DB Source component which references the OLE DB connection manager.

6) Insert the underlying query of the SSRS report into the OLE DB Source component the data flow,

7) Create a flat file  connection manager where you can define in more detail how the CSV file is to be created (making sure the check box labelled "Column names  in the first data row") is unchecked.

8) Create a flat file destination component which refers to be flat file connection manager you just created.

9) Drag the green arrow from the OLE DB Source component  to the flat file destination.

I hope the above helps.

Kieran.

 

Answer 4

Peedoe,

You can tell reporting services to not include  the header  by setting the "NoHeader" parameter. look at the link qxg provided.


Ryan Duclos
Twitter: @rduclos
Blog: http://rduclos.wordpress.com
 

Answer 5

Hi All,

It's not really blank and white which solution we should choose. I've looked at the link; - http://msdn.microsoft.com/en-us/library/ms155365.aspx which provides an option  to disable the Header row  within SSRS. However the thread http://blogs.infosupport.com/blogs/marks/archive/2010/04/18/modify-reporting-services-export-to-csv-behavior.aspx also indicates there are issues with this solution.

I still vote that creating a simple SSIS package is the easiest, least risky and most robust solution. However it also partly depends on how technical Peedoe want's to be the SSIS solution is the least technical. However I am open to learn.

This type of question has already been asked very frequently, please have a look at similar threads; -

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/9a19c1b9-c809-4c21-b302-876b77e55074

and

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/94abbea2-2c40-430f-a5a3-6eb357409b55

I hope this helps,

Kind Regards,

Kieran.


If you have found any of my posts helpful then please vote them as helpful. Kieran Wood PGD SoftDev (Open), MBCS http://uk.linkedin.com/in/bileeds
 
 
 

<< Previous      Next >>


Microsoft   |   Windows   |   Visual Studio   |   Follow us on Twitter