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?
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
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!
Business Accounts
Answer for Membership
by: rhinokPosted on 2009-05-04 at 11:21:54ID: 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:
- Create HKEY_LOCAL_MACHINE\SOFTWAR
- Add DatabaseOptions under Crystal Reports.
- Add LOV under DatabaseOptions.
- Add Stringkey MaxRowsetRecords under LOV
- 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