• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3121
  • Last Modified:

Dynamic Parameter limit in Crystal Reports Server 2008

In Crystal XI, we had the issue with only so many values showing up in dynamic parameter lists.  We fixed that via the MaxRowSetRecords registry entry.  Now we have upgraded to Crystal Reports Server 2008, and have the same problem.  This time, however, that registry entry did not fix the problem.  There must be a different way to fix this in Crystal Reports 2008?
0
jhardwood
Asked:
jhardwood
1 Solution
 
Kurt ReinhardtSr. Business Intelligence Consultant/ArchitectCommented:
Unlike prior versions of Crystal Reports, Crystal Reports 2008 lets you break up a long list of values into chunks, making it much more user friendly.  It also gives you the end user the ability to filter and search for parameter values.  The chunks have predefined limits, but the number of chunks is limited to 5, by default.  The MaxRowsetRecords registry hack still works, but you need to apply it in the right place.  Also, by increasing the number of records allowed, it increases the number of chunks.  To create the key:

  1. Create HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\Crystal Reports\DatabaseOptions\LOV
  2. Add DatabaseOptions under Crystal Reports.
  3. Add LOV under DatabaseOptions.
  4. Add Stringkey MaxRowsetRecords under LOV
  5. Set value to maximum number of records to read - whatever is appropriate for your environment
FYI - I just tested this against my client's list of employees (>13k employees) and it worked well.

On a side note, the filtering feature works great, but can be a little confusing.  In my case, the parameter value I created was a numeric value, because the employee IDs are numeric.  These show up with a comma in the parameter list, since they're numbers (ex: 1,111).  When you want to filter against numbers, you need to include the comma.  So, if I was looking for all of the employees starting with the "16 thousand" numbers, I'd use a "16," as the filter.  No wildcard is necessary.  This would return all employees starting with "16," (16,000 - 16,999).  Please note, the quotes aren't necessary, either.  I just used them within the sentence.

~Kurt
0
 
jhardwoodAuthor Commented:
Thanks.  I just now noticed the control below that allows the user to select the "chunks".  I had added the registry key earlier, but it didn't look like it had done anything, because all the time I was not seeing the "chunk" selector.  Now I see that the registry key is allowing me to have more chunks of data.  EXCELLENT!  THANKS!
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now