multiple formats in Cross-tab Crystal reports 2008

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.
gilweber3Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
mlmccConnect With a Mentor Commented:
Something more like

If (CurrentColumnIndex = GetIndexOf("ColumnField","Penetration Rate") then
    CStr(CurrentGridValue,2) & "%"
Else
    CStr(CurrentGridValue)

mlmcc
0
 
mlmccCommented:
Have you looked at using the Grid Value Functions?

The CurrentColumnIndex returns the column number of the cell
GetIndexOf("FieldName","ColumnName  to Find")

mlmcc
0
 
gilweber3Author Commented:
I am assuming what this means is you put in a 'name of the field' it returns the index number( column number) based on that you run something like this:

f (CurrentColumnIndex  = 2) = 0 then
"%" else ""
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.