I have joined several tables for a report. The hospital table includes volume targets. The procedure table contains individual cases including submitting hospital and procedure type.
The main report groups on hospital. A subreport groups the same data by procedure type. The data is grouped (and sorted) by procedure type and is denormalized after the merge for the report.
I wish to sum the targets in the hospitals table. That is, one target value for each hospital.
I would appreciate any help with that.
eddy
IP Logged