Conditional number formatting at run time...

[BluByU]

Hello:

I have an emissions report that prints out emissions data to the precision of 2 decimal places. However, certain emissions are very small, so if a pollutant has an emissions amount of < 0.01, then I need to change the number field's formatting. I need 6 decimal places of precision and rounding to the same precision as well. What formula will perform this at run time?

I tried a suggestion I found in the Crystal Reports knowledge base, but it returned run time errors every time I ran the report. Thanks in advance for your help!

 

[synapsevampire]

Right click the number and select format field->Number->Cusotmize->X 2 next to Decimals and place something like:

if {table.Amount} < .001 then
6
else
3

You'll also want to do something like this on the round formula (X 2 next to rounding).

If this doesn't work, please share what you tried and the error returned.

-k