SAP Knowledge Base Article - Public

2256996 - Empty or uncomplete list in Crystal Reports browse data function

Symptom

  • Not all the values are shown in the "Browse Data..." function of Crystal Reports

Environment

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

Reproducing the Issue

  1. Open Crystal Reports designer
  2. Create a report against data source (For example a BEX query) that contains large number of records (~100.000) where the first thousands of record values of a field are empty (or space string)
  3. In the "Field Explorer" right click on a field and select "Browse data..."
    BrowseData.jpg
  4. Observe, that the list is empty
    EmptyData.jpg

Cause

  • This can be a by design behaviour of the product
  • This function is intended only, to pick some samples from the values
  • By default, it is not necessarily providing all the different values present in the data source
  • Crystal has 2 limits on this functionality (to maintain good performance)
    1. Timeout (in seconds)
    2. Number of distinct values
  • If either of them reached, Crystal stops collecting the values
  • If the Timeout limit is reached while Crystal is still browsing at the section where the data source has empty or " " values, the result list seems empty

Resolution

  • Check KBA 2165260 on how to change the "BrowseTimeout" and "MaxNBrowseValues" registry keys

Keywords

crystal, reports, browse, browsing, data, sample, timeout, limit, maximum, distinct, , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016