SAP Knowledge Base Article - Preview

1576905 - Report containing linked subreports takes long time to refresh, when there is no data in the main report in Crystal Reports

Symptom

  • Report performance issue.
  • Report takes a long time to refresh despite the report returns no data.
  • The same report used to refresh quickly when no data were returned.
  • Linked subreport sending an SQL Query to the database with no Where Clause.
  • Reports that contains at least one linked subreport takes a while to run when the main reports returns no data in Crystal Reports.
  • Linked subreport refresh when the main report returns no data.


Read more...

Environment

  • SAP Crystal Reports 2008 with Service Pack 3 and higher
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013

Product

Crystal Reports 2008 V0 ; Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2011, feature pack 03

Keywords

Crystal Reports, CR, Subreports, Performance issue, Slow report, SQL Query , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.