- Blank report.
- Report with linked subreport(s) are blank, but subreports with no links returns data.
- Unable to drill-down on a blank subreport in Crystal Reports when the main reports returns no data.
- How to automatically display subreport data when the main report returns no data, or when the main report has no data source?
- SAP Crystal Reports 2013
- SAP Crystal Reports 2016
- SAP Crystal Reports 2020
Reproducing the Issue
- In Crystal Reports, create a new report with no data source.
( The main report will be used as a container of one or more subreports. )
- Suppress all the sections of the report except the Page Header, Page Footer, and Report Footer.
- Insert one or more subreport on the report. For example, in the Report Footer section.
- Create parameter on the main report.
- Link the main report parameter to the subreport(s)
- When refreshing the report, it returns nothing. It is blank.
- The reason this situation occurs, it's because the main report does not have a data source, and therefore it will not be executing subreports that are linked because the subreport depends on the main report, and since there is no data on the main report, the subreport will not be executed.
- When a report contains linked subreport(s), the main report needs to return at least one record for the subreport(s) to be executed.
To ensure the main report returns at least one record on the main report:
- Add a data source connection to the main report, and add one table that returns at least one record.
( If the table return more than one record, you can create a record selection that filter the data to return one or few
records, as the main purpose is not to return a lot of records, but to have at least one record on the main report. )
- Place a database field into the details section of the main report.
- Suppress the Details section.
- Now, when refreshing the report, it will always execute the linked subreports.
- Right click on the subreport, and select "Format Subreport..."
- In the "Format Editor", under the tab "Subreport", check the option "On-demand Subreport"
- Click "OK" to accept the change.
SUBREPORT NO RECORDS BLANK LINKING DOUBLE CLICK DISPLAY Seagate Crystal Reports Seagate Info Subreports , CR , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem
SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020