I'm a beginner with CR8.5 and I'm trying to learn the TONUMBER command and how to use it in a simple report that I created. The data in some of the key fields I need in my report are coming into my report as a text fields and as a result I cannot use any of the calculation options (Grand Total, etc.) in CR8.5 I've read and understand that I need to incorporate the TONUMBER statement into my query but I'm not familiar with the syntax to use. Can anyone tell me where and how to input the command in the SQL script below to get the 'billed, paid' fields processed as numbers rather then text.
Thanks,
Rudy
SELECT DISTINCT
RS.`FILE_NAME`, RS.`CLAIM_DATE`, RS.`WARRANT1`, RS.`CLIENTNAME`, RS.`CLNTNUMBER`, RS.`GROUP`, RS.`PERIODFROM`, RS.`PERIODTO`, RS.`BILL`, RS.`RATE`, RS.`BILLED`, RS.`PAID`, RS.`EOB`, RS.`CONTRACT`, RS.`UBILLED`, RS.`UPAID`, RS.`BILL_FILE`
FROM
`RS` RS
ORDER BY
RS.`CLAIM_DATE` ASC
Thanks,
Rudy
SELECT DISTINCT
RS.`FILE_NAME`, RS.`CLAIM_DATE`, RS.`WARRANT1`, RS.`CLIENTNAME`, RS.`CLNTNUMBER`, RS.`GROUP`, RS.`PERIODFROM`, RS.`PERIODTO`, RS.`BILL`, RS.`RATE`, RS.`BILLED`, RS.`PAID`, RS.`EOB`, RS.`CONTRACT`, RS.`UBILLED`, RS.`UPAID`, RS.`BILL_FILE`
FROM
`RS` RS
ORDER BY
RS.`CLAIM_DATE` ASC