Exported CSV files - header on EVERY row

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

Exported CSV files - header on EVERY row

Author

Topic

RiddleMeThis
Starting Member

4 Posts

Posted - 2010-03-29 : 10:22:11

In SSRS, when a report is exported to csv it seems to output in the following format:


<HEADER> <FOOTER> <DETAIL1> 
<HEADER> <FOOTER> <DETAIL2> 
<HEADER> <FOOTER> <DETAIL3> 
<HEADER> <FOOTER> <DETAIL4>

and repeats like this for every row, repeating the header and footer on every line.

However I want it to output the header at the top of the csv, then all the detail rows, then the footer at the bottom, like this:

<HEADER> 
<DETAIL1> 
<DETAIL2> 
<DETAIL3> 
<DETAIL4> 
<FOOTER>

Does anyone know how to accomplish this?

sherrireid
Yak Posting Veteran

58 Posts

Posted - 2010-03-29 : 17:31:59

I wonder if there is something kinky going on somewhere - when we export to csv it does it in the format that you would like it to. We have never had a problem like you describe. I don't know what to tell you to resolve the problem, but I thought knowing that we don't have that problem might help you in trying to research the problem. Regards --Sherri Reid

SLReid
Forum Newbie
Renton, WA USA

RiddleMeThis
Starting Member

4 Posts

Posted - 2010-03-30 : 03:04:40

Hi Sherri, thanks for the post, thats good to know (depending how you look at it), at least now I know it's a problem and not just how it normally outputs!

RiddleMeThis
Starting Member

4 Posts

Posted - 2010-03-30 : 06:18:13

UPDATE:
I should have mentioned, it might be relevant i dont know, but it currently outputs the name of the cells first, then the output as i described, like this:

<CELL NAME> <CELL NAME> <CELL NAME>
<HEADER> <FOOTER> <DETAIL1> 
<HEADER> <FOOTER> <DETAIL2> 
<HEADER> <FOOTER> <DETAIL3> 
<HEADER> <FOOTER> <DETAIL4>

RiddleMeThis
Starting Member

4 Posts

Posted - 2010-04-06 : 11:25:02

ANOTHER UPDATE:

Just realised, I was thinking this was happening at the SSRS webserver side of things, but it actually happens right from the report design stage in Visual Studio 2005.
I dont see that it can be a problem in the SQL as the SQL is only used to generate the body, it seems like its a report property somewhere that needs to change, but I can't see any relevent property dialogs or attributes.

Does anyone have any ideas?

Thanks

Tones
Starting Member

17 Posts

Posted - 2010-11-29 : 11:07:29

Did you ever manage to find a solution to this. I have been trying different things for a few days and searching online but have been unable to find a proper answer to this problem.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources