How to use subreport to display report header when main report is empty?
I'm creating several reports for our company. And we would like to keep the headers of the reports consistent across all of the reports. I've created a subreport with the correct format for the header and inserted into the main report's Page header section, and use parameters to pass in the report name and such. However, whenever the main report returns an empty set of data, the subreport doesn't gets displayed.
Is there anyway to get around this problem?
Since the subreport is linked with the main report parameters if the parameters are empty then the subreport will not return any headers. Check whether the parameters are linked to subreport database fields. If so uncheck the subreport database fields and just pass the parameter values from main report to subreport without linkung to subreport DB fields. After passing the parameters check whether the parameter value is null or not using the function isnull(). if it is null then use some constant string like "Empty" else use parameter field value.