Sage 100

Working on a CR with a subreport - in this instance, sometimes the subreport has no data to report - I need it to display some kind of message when this happens like 'Call Us' or some such. Not having any luck. Anybody run across this before?

You should be able to put your message in the report header or footer of the subreport which will print regardless of whether there is data found or not. Then you'd have to suppress it if record count was > than 0. Something like that should work.

could it be that whatever link you are using to the subreport is failing when there are no records that would cause the subreport not to run at all? If so set a shared variable in the subreport and put the your message text on the main report and suppress it when the shared variable has a value. Of course you will need to reset the shared variable to null in the main report before the subreport runs each time.

@DavidOverholt the subreport's not going to know if there are matching records or not until it runs. @RandyMarion I just tested my method and it works. I put a message in the subreport's report footer and then created a count summary field of one of my fields in the subreport. That count summary is null if there are no matching records at all. I checked and suppressed my message if the count wasn't null.

Thanks to @DavidOverholt and @BrettLyder for good ideas. Given the report I was working with, I went with the message in the footer and after some fiddling around, got the suppression to work the way the client wants. I certainly appreciate the help.