Hi,
I Have a subreport called in the main report.
I'm using a table in the subreport and another in the main report. Both r linked by timestamp(dateTime).
In the subreport, i have 3 fields. the report footer a contains the summery of each field. the report footer b contains the fomulas to calculate the average of each field. the report footer c contains the grand total(shared variables) of the each field.
In the main report under the group footer,the summary of activities of an agent is generated which includes the subreport.the report footer contains the grand total. the fields in the main report produces correct grand total but for subreport which is called using the shared variable, it displays the last record of the summery. meaning the time range is bet 12:00AM to 11:45PM.So the grandtotal for fields in the subreport displays the summmary of the record at 11:45PM.
can someone pls advice me on how to get the correct grand total values for subreport in main report.
thanks!
19:00 1 0 1 0.00 0.00 107.00 63.00 0.00 63.00 0.02
19:15 0 0 0 0.00 0.00 0.00
19:30 1 0 1 100.00 0.00 5.00 10.00 25.00 35.00 0.00
19:45 1 0 1 100.00 0.00 3.00 238.00 5.00 243.00 0.07
I Have a subreport called in the main report.
I'm using a table in the subreport and another in the main report. Both r linked by timestamp(dateTime).
In the subreport, i have 3 fields. the report footer a contains the summery of each field. the report footer b contains the fomulas to calculate the average of each field. the report footer c contains the grand total(shared variables) of the each field.
In the main report under the group footer,the summary of activities of an agent is generated which includes the subreport.the report footer contains the grand total. the fields in the main report produces correct grand total but for subreport which is called using the shared variable, it displays the last record of the summery. meaning the time range is bet 12:00AM to 11:45PM.So the grandtotal for fields in the subreport displays the summmary of the record at 11:45PM.
can someone pls advice me on how to get the correct grand total values for subreport in main report.
thanks!
19:00 1 0 1 0.00 0.00 107.00 63.00 0.00 63.00 0.02
19:15 0 0 0 0.00 0.00 0.00
19:30 1 0 1 100.00 0.00 5.00 10.00 25.00 35.00 0.00
19:45 1 0 1 100.00 0.00 3.00 238.00 5.00 243.00 0.07