I have a current solution that received three tables, one is the parent table, one is the main set of child records, and the third is an optional set of child records. The third set prints as a subreport.

I would like to include a field in the parent table that indicates if the subreport should be printed or not. If the field is true, then the subreport prints. If the field is false, then a text string is printed instead and the space is conserved.

Is this possible and can you point me in the right direction?

I've read how to make the subreport option using a second copy if itself, but I'd like to make the report operation quicker by making the decision in code ahead of time. Also it didn't show how to replace the subreport with a text string.

Thanks,
Bernie