HELP!!!!
I have a report that has three subreports, each having a sum text box (subtotals). The main reports then sums the subtotals into a grand total. There will be cases where the subreport doesn't have any data.
The problem is that, for some reason, the report works perfectly in Report View. When a subreport has no data, the subtotal is shown as 0 and the grand total works fine. But when I go to print it (or print preview), the subreport that has no data disappears and then the grand total shows "#Error".
I would like to leave the subreport as visible even if there's no data in it (to explicitly show that there is no products in that category for the current quote).
Can anybody help me???
Thanks in advance.
Doug