multiple formats in Cross-tab Crystal reports 2008
Posted on 2013-11-04
I have yet to find the answer to this question so I will throw it out there.
I am working on a cross tab in Crystal the problem is that some of the numbers will be formatted as percents and some of the others will be in whole numbers or dollars. The problem is when I try to format based on the 'data' I want to change it changes all of the formats for all of the fields not just that 'column' The amount of columns is dynamic but I do have a field name so ideally if I can format 'if field name is avg products' leave alone, 'if field name is total loans' make dollar sign and finally 'if field name penetration rate' format %.
hope this makes sense.