Solved

Dynamic Parameter limit in Crystal Reports Server 2008

Posted on 2009-05-04
2
3,081 Views
Last Modified: 2012-05-09
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
Comment
Question by:jhardwood
2 Comments
 
LVL 26

Accepted Solution

by:
Kurt Reinhardt earned 500 total points
ID: 24297711
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
 

Author Closing Comment

by:jhardwood
ID: 31577630
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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question