Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

CSV file format export and leading zeroes. Expand / Collapse
Author
Message
Posted Friday, August 22, 2014 8:18 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: 2 days ago @ 6:34 AM
Points: 22, Visits: 33
I was asked to do this for ICD-9 diagnosis fields that may have leading or trailing zeros to be retained in CSV export from SSRS 2008 R2. Example is 090.10 for a diagnosis. I found that adding a carriage return to the expression in Visual Studio will preserve the zeros! Looks good in regular Excel/PDF output and print as well.

Fields!diag_field.Value + chr(13)
Post #1606320
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse