Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Exporting to CSV Expand / Collapse
Author
Message
Posted Wednesday, May 22, 2013 6:46 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: 2 days ago @ 8:42 AM
Points: 14, Visits: 230
Is there anyway to control how a SSRS report exports to CSV?

Q1. The report has 15 columns. Is it possible on the .CSV for the first three columns to appear on the first row and the remaining columns to appear on all other rows?

Q2. Is it possible on the .CSV to show an extra line to show between groups?

Thanks in advance.

Michael
Post #1455466
Posted Wednesday, May 22, 2013 9:01 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, December 2, 2014 12:03 AM
Points: 556, Visits: 446
Generate the data result in that manner, probably with two different query's and column list.
Post #1455566
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse