Solved

Dynamic Parameter limit in Crystal Reports Server 2008

Posted on 2009-05-04
2
3,066 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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

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…
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

759 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now