Calculated fields in aggregated reports

Hi,

does somebody know a solution how to show calculated fields in aggregated report, I have a datasource with sum function used for grid and report, for other reports without aggregation I defined display methods on underlaying table, but in aggregation this doesn’t work?

Thanks

Tomas

Hi Tomas,

Remember, when u r puting aggregate functions, the select queries return you the fields, those are specified with select and specified with group by caluse.

To test ur report data, simply write a select query something like select sum(ur field), from group by where .

Try to do some test by changing the select query group by fields and select fields.

Hope it helps…