June 4, 2014 at 10:57 am
In a new SSRS 2008 report, I would like to know if there is a way to automatically expand the width of some of the rows when the data is exported to a CSV file so the data is displayed correctly. Here are examples that I am referring to:
1. In one column where there is suppose to be a date that looks like 12/11/2014, the value of ########## is displayed. The value of 12/11/2014 is what is setup in the SSRS formatting option.
2. In a number field that is suppose to look like 6039267049 the value that is displayed is 6E+09.
Basically if I manually expand the width of the columns that I am referring to above, the data is displayed correctly. Thus can you tell me what I can do so that the data is disaplayed correctly in the CSV file and ther user does not need to manually expand the column to see the data?
June 4, 2014 at 11:58 am
If you are exporting to csv there is no width, Excel is just using the default cell sizes when you open the csv. There's nothing you can do from SSRS to fix that since SSRS is just outputting something like this:
lastName,firstName,DOB,phone
Corbett,Jack,1/1/2001,1234567890
Doe,John,12/31/2000,0987654321
Have you tried using export to Excel instead of csv?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply