I have a report with five subreports. Each of the subreports has a calculated total. In the main report the totals of subreport 1, 2 and 5 are summed.
If subreport 2 has no data, it is not shown in the report, which is what I want . However, consequently, there is no subreport total, so the sum in the mainreport gives an #error nz() does not work, because the subreport.total does not exist at all. Any idea how to solve this? I tried playing with hasdata, but lost track.
Thank you in advance,
Last edited by PJThys; 05-18-04 at 17:23.
Reason: correct spelling error