Crystal 8.5 Report formula error

[jpeters01]

Hi, We still have an application that uses Crystal 8.5 and I need to modify one of the "standard" reports that comes with the application. It contains this formula: "QTY:" + NumberFormat(({TABLE.QTY}*{TABLE.DISPENSESIZE}),0) but I can't get the standard report to run outside of the application. When I check the formula I get an error "A number,currency amount, boolean, date, time, date-time, or string is expected here. Both Table.Qty and Table.Dispensesize field types are numbers. What is "numberformat"?

 

[Turkbear]

Hi,
The application must use a custom user-defined function that is not avaliable outside of it.

Try using the help files to see what Crystal function(s) will format the numbers the way you want ( if any)





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[IanWaterman]

Numberformat() is not a crystal function so no idea how it even runs in your application.

you need to use totext()

Try

"QTY:" + Totext(({TABLE.QTY}*{TABLE.DISPENSESIZE}),0)

Ian

 

[jpeters01]

I replaced the numberformat() with totext() on approximately 5 formulas in the report. Will see if I can format the numbers and/or look at the other Crystal functions...thanks!