Hi people, i'm editting a report in Crystal 11 for a client. The database field is @sQTY(string) and it populates the collum with quantity figgures. I want to remove the current decimal places from 7.2000 to 7.2.

If i rightclick on it and go to "format field...", i do not get the "numbers" tab to change the decimal places. Formula currently looks like this:

ToText({OEORDD.QTYORDERED},ToNumber({?QTYDEC}))

Its a SQL database, using Accpac ERP.The first section is the Database table and the Field and i presume the second on is the crystal one. Do i need to change this formula and any ideas what is should be?

Thanks

The 2nd argument is the number of decimals.

Maybe instead of using a formula for the field you can just drag {OEORDD.QTYORDERED} into the report and then format field?

Since the formula returns a string, it would make sense that you are not getting a Number tab.

But I am curious whaT QTYDEC is about. Is it the number of decimals for the particular value and that it was decided it is no longer necessary?

Edited by Keikoku - 10 Jan 2011 at 6:34am