Hi,
I have 1 main report which uses 1 table and a subreport using another table. Both tables r linked by time.
The report displays the summary of abt 40 users' activities bet 12am till 11.45pm. And then i need to get the grand total for each field.
My problem is:
1) how do I generate the grandtotal value? I can't possibly create a formula like: Sum(Sum({fieldName})) for the grandtotal. Is there anyway to get a grandtotal for a formula?
2)How to display the grandtotal of the subreport fields in the main report?
regards,
I have 1 main report which uses 1 table and a subreport using another table. Both tables r linked by time.
The report displays the summary of abt 40 users' activities bet 12am till 11.45pm. And then i need to get the grand total for each field.
My problem is:
1) how do I generate the grandtotal value? I can't possibly create a formula like: Sum(Sum({fieldName})) for the grandtotal. Is there anyway to get a grandtotal for a formula?
2)How to display the grandtotal of the subreport fields in the main report?
regards,