Hi,

Results can be of the format 123.2 or 0.124. I haven't found number formatting that will accommodate all.

If I use 3 decimals, 0.124 works but 123.200 does not - and vice versa for 1 decimal.

What number/decimal conditional formatting can I apply that will work for all cases and is dependent on the data?

Thanks!

That may help...thanks.

To be clear though, I just used the one/three decimal as an example. Some data may come over as two, some data may come over as a whole number. Whatever the case may be, I need the report to accommodate the real data.

Thanks

Sure..just like in my original example.
Results in my database could be:
0.123
3.124
7.6
6
0.12565
etc.

I want the report to display the data exactly as it is in the database, which varies the # of decimal places.

Hi

Number fields display data based on your local system number format unless you format the fields in crystal.

To address your issue, you need to write a free hand SQL and convert your number field to text and insert into your report to get original format.

After inserting if you want to insert any totals based on the field then use Tonumber().