asked
Export to csv
Hello All, I am using SSRS 2008 R2. I have developed a report and one of the columns returning values as 0113,0234. when i am exporting to CSV format it is showing as 113,234. I want to 0 also to be the part of that number. Please give me the solution.
This site runs off of votes. Please mark all helpful answers by clicking on the thumbs up next to those answers. If any one answer lead to a solution, please indicate that by clicking on the check mark next to that answer.
One option is to convert the field to a string within the report, so when it exports to excel it doesn't treat it as a number. [
http://msdn.microsoft.com/en-us/library/ms157328.aspx][1] [1]:
http://msdn.microsoft.com/en-us/library/ms157328.aspx
Thanks for your reply. I am already converting my values into string (=Cstr(field)). I don't want to export it in Excel. I want it in CSV.
As you say that you are already getting the leading zeros in a number, this means you have already converted that in string.[CAST('00000'as varchar)] Then there should be no issue in exporting to CSV. I did the same thing and got all leading zeros. Name,Number A,10001 B,10001 C,010001 D,10001 E,00000 You must be opening the CSV in Excel, try to open that in notepad. You will get all the leading zeros. Excel treat them as numbers, so will definitely remove zeros.
16 People are following this question.
