Reporting service to export CSV

• Casper101

  Hall of Fame

  Points: 3903

  More actions

  January 6, 2009 at 7:23 am

  #217181

  Hi,

  I am using SSRS to create a report. When this report is exported to a CSV file, it must make all columns the same width.

  So I am looking at creating a fixed-width column CSV file. I have created all the columns in the design view with the same width in centimeters - but this of course has not affect in a CSV's column widths.

  So when you open the file in Notepad it will look something like this: (each column being 10 chars in width)

  abc ,12345 ,a1b2c3d4e5

  adhffg ,9876 ,kjkdkd

  asdfoplk ,84749 ,jjhtkjfll

  How can this be done?

• Ray M

  SSC-Insane

  Points: 21093

  More actions

  January 6, 2009 at 12:44 pm

  #922065

  Unfortunatelly I don't think RS export works that way.

  You can try altering your dataset.

  Select (Cast Col1 as char(100)) as Col1, Cast(Col2 as char(25)) as Col2.....

  From Mytable

• Casper101

  Hall of Fame

  Points: 3903

  More actions

  January 7, 2009 at 1:41 am

  #922352

  Thanks - I tried your suggestion -works just fine.

  Appreciate it!!