This is the first time I've used subreports. I've got a linked subreport, which fetches data from another table based on a parameter (the current item code).
It's working fine, except for the case where the subreport gets no records. In that case, I have two problems:
1. The title line is a formula, like "N kits use this item code". When there are no records, the formula doesn't display. (When the count of kits in the report is 0, It's supposed to say "*** No kits use this item. ***")
2. The column headings in the subreport always print, no matter what. I can't suppress them no matter what I try.
Both are driven by the count of returned records (count(command.kitnumber)=0) so maybe there's something I don't understand about the interaction between the main report and the subreport.
Where should I look?