Has anybody changed the report criteria at all recently (ie after the last time it was used with no problem)?

This error is described in the QR manual, Appendix A, page A-13. It appears when the 'ToNumber' function is being used (for example in the selection formula) in the wrong context, or the text string being converted does not contain the expected 'number'. The argument to the ToNumber function must be a text string containing a number. (Optionally preceded by a minus sign. Leading and trailing blanks are also allowed.)

For example (from page 8-23 in the QR manual) -

ToNumber (x)
Converts a text string to a number.

Example 1:
ToNumber("123.45") will result in 123.45.

ToNumber ({Reference}) will result in 200.00, where "200" is the text string in the {Reference} field.

Check any formulas in the report to ensure that the syntax is correct and try again. Perhaps one of the fields in the formula does not contain a number where it is expected.

The Customer Number and Customer Name fields are text strings that MAY contain numbers or not, but if they do NOT - you would get an error such as this one.

The field Invoice Date is a Date field so unless you are using some complicated formula to convert the components of that to a text string, I doubt this is the field being referred to. It is likely that similar circumstances apply to the 'Sales' although since you have not indicated whether or not this is a formula or one of the Sales figure fields it is hard to comment further apart from saying that the fields themselves are number fields, so you would not use the 'ToNumber' function on these types of course.

Hope this helps!

Regards
Softrak Support

[This message has been edited by Softrak Support (edited 10-01-2001).]