Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Dynamic Parameter limit in Crystal Reports Server 2008

Posted on 2009-05-04
2
Medium Priority
?
3,112 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
[X]
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
2 Comments
 
LVL 26

Accepted Solution

by:
Kurt Reinhardt earned 2000 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…

670 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