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.
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.