Reports Calculation

Hi,

Can anyone assist. I have a report based on a grouped query with a calculated sum total in the query. The query works fine and the report runs against it. I need an additional calculation per row of the report. It is based on one field in the query less the calculated summary field. This can be added in the query and the query works but the report won't. So is it possible to add or subtract two controls on the row of a report and have a calculated control holding the answer ?



Message forwarded from pcsoft.us.windev

Yes, you can.
You can put code in the report like in any window.

Hi Denis,

You don't need to include the calculation in the query. Just create a calcutaled control. In the code section "before printing" you add this code:

CALC_MyCalc=MySource.Field1-MySource.Field2
//or MySelf=MySource.Field1-MySource.Field2

With MySource.QueryItemName you can use any query item in code.

Best regards,
Piet