Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Dynamic Parameter limit in Crystal Reports Server 2008

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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
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…

856 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