Hi,
Calculated fields are not held in tables, they only exist temporarily as the result of a calculation when your program runs.
In your example, 'price' is held in your invoiceline table and 'quantity' is held in your invoiceline table, but 'linevalue' does not need to be stored in your invoiceline table - it is derived by the calculation of 'price' * 'quantity'.
For this reason, If you use 'reportsql', you can't reference calculated fields because they do not exist!
However, you simply need to replicate the formula to calculate the linevalue inside your reportsql if you need to see linevalue.
Have a look at the attachment.
Derek.