Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 265
  • Last Modified:

Reporting Services 2005 Rendering as a CSV file but without any headers

Hi all

I want to render out a CSV file in reporting Services 2005, but I don't want RS to put in the header rows, I just want the data, is there anyway or anyhow of turning the headers for just this report off, or hiding them?

Thanks

David
0
DavidGreenfield
Asked:
DavidGreenfield
1 Solution
 
regbesCommented:
Hi DavidGreenfield,

Remove all the col headings from the layout view


HTH

R.
0
 
DavidGreenfieldAuthor Commented:
That obviously doesn't work, the column headings when saving a report as a CSV come from the name in the properties window of each cell of the table, and the properties name obviously has to be unique so you can not set it to nothing.
0
 
chrismcCommented:
Hi David,
The export to CSV is very basic in RS, it just dumps the data out, including headings. You have no control over it.
To do this properly, you should create a DTS/SSIS package to do it, that is it's purpose. The package can be scheduled too.

Cheers
Chris
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now