SAP Knowledge Base Article - Public

2312618 - Sequential processing causes longer runtime in Crystal Reports with subreports in details

Symptom

  • The SQL query of the main report takes X seconds
  • The SQL query of the subreport takes Y seconds
  • Refreshing the report takes considerably more time than X+Y seconds

Environment

  • SAP Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016

Reproducing the Issue

  1. Create a Crystal report that takes 5-6 seconds to refresh
  2. Insert a subreport (that takes also 5-6 seconds) into the details, so that it's repeated multiple times
  3. Observe, that refreshing the whole report takes more than 10-12 seconds

Cause

  • In Crystal Reports the subreports are evaluated after each other
  • The SQL call of the second subreport will start after the data is retrieved for the first one (and so on)
  • This means, the refresh time will be (the runtime of the subreport alone) * (number of the subreport instances)

Resolution

  • This is a by design behaviour of the product
  • Currently it's not possible to run the subreports parallelly, therefore it is not suggested to put a subreport in the details section
  • Workaround: use on-demand subreports

Keywords

subreports, performance, parallel, at, once, same, time, SQL, query, on, demand, run, process, evaluate, result, finish, time, runtime, refresh, runtime, long, slow , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016