ok so im kind of a noobi when it comes to crystal... and i tend to take the easy way out (for me anyway)...i write most of my reports in SQL server then just convert the parameters to crystal syntax etc...

i needed a report that would be a crosstab... 

 

BDM                 Recruiter                      Type                 Apr       May

Lingenfelter       Beedenbender              %APD             0.81     1.14

Lingenfelter       Beedenbender              %EPD              1.09     1.20

Lingenfelter       Beedenbender              APD                909      1362

Lingenfelter       Beedenbender              EPD                 1224    1432

Lingenfelter       Beedenbender              Goal                 1116    1189

 

 

So i wrote it out in sql first... the only problem is that the "TYPE" field needs to have different formats depending on the result... so where "Type" = %APD i have to format the corresponding numbers as percentages....

 

how or where can i put a formual that will only format those that are less then 2 into a percentage?

 

I hope that makes sense….

 

 

phew...  if you dont use crystal every day it can sure be a fustrating pain the in the "you know what"

 

Thank you again!