Render CSV with different row header format,detail format, footer format, is possible?

• sqlagent007

  SSC Enthusiast

  Points: 158

  More actions

  May 29, 2013 at 9:18 pm

  #294533

  I am just trying for fulfil the request of my task master. I know there are better tools (ssis) for this but I am going to ask any way. We are using SQL SERVER 2008 R2

  I am trying to create a ssrs report with csv rendering in the following format.

  H,20130501,0000022

  D, ABC,DDD, EEE, 10.50

  D, ABC,SDD, EEE, 9.50

  D, ABC,YDD, EEE, 200.00

  T,000003,220.00

  My task master will not be happy with doing all the concatination in a sproc. Has anybody done something similar? Is possible in SSRS ?

• HanShi

  SSC-Dedicated

  Points: 33506

  More actions

  May 30, 2013 at 12:38 am

  #1619565

  I guess you can define multiple datasets in your report. Display the resultset of each dataset in the desired format.

  ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **