I'm on Crystal 2008. I've created a report where I had to created text fields with static data. For example, one data field must appear as 015. this also needs to be exported to CSV. When we export to .csv, I lose the leading zero.

 

How do I preserve the formatting so it preserves the leading zero AND preserves the text field as text? Thanks!

What formula do you suggest I use to save the formatting of this field? But also, for other reports where I have to pull in data fields that have leading zeros (vs creating a text field and adding static values), what would the steps be to preserve that as well?

 

I was just directed to this link that suggests my request is not possible (or at least, more steps will be required), but hoping for a 2nd opinion.

 

http://www.upenn.edu/computing/da/bo/webi/qna/iv_csvLeadingZeros.html