Solved

Crystal XI Dynamic Parameter Not Displaying All Available Values

Posted on 2010-08-20
5
804 Views
Last Modified: 2013-11-16
I have a crystal report that is using a stored procedure to display the data.  When I run the stored procedure all the customer's names are displayed.  However when I set up a dynamic parameter in the crystal report where you can select multiple customer names it only populates the values for some of the customers.  Is there some sort of limit or filter on the number of values that can be populated in a dynamic parameter.  It may be pulling 50 names right now at the most. There should be about 350 names available.  Please advise.
0
Comment
Question by:Shumai1
5 Comments
 
LVL 3

Expert Comment

by:Orion Newman
Comment Utility
there isn't a limit like that. Are you sure that the records all have data that can be used to filter on? Meaning there aren't any null values or blank fields....that you are trying to filter on

i have had that happen before.


0
 

Author Comment

by:Shumai1
Comment Utility
Yes they all have data.  If I run my stored procedure in query analyzer I can see all the names displayed.  Also if I take out the parameter and type in a name in the select expert that was not populated by the dynamic parameter I received data for that customer.
0
 
LVL 2

Accepted Solution

by:
bischofb_CRNET earned 125 total points
Comment Utility
To remove the limit of how many records are returned from a dynamic parameter, do the following:

Find this folder in your registry (click Windows Start > Run > RedEdit) and drill down to it.
 
HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 11.0\Crystal Reports\DatabaseOptions\LOV
 
Then add the following String Value:
 
MaxRowsetRecords
 
Set it to a very large number (note: If you have a lot of duplicates in your data, all the records are counted even though only a few might be shown).
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
The default limit on parameter values is 1000 if you only have 300 or so records, then you shouldn't be running into that limit.

How are you running the report?

Is the report using the SP directly or through a Crystal Command?

mlmcc
0
 
LVL 2

Expert Comment

by:bischofb_CRNET
Comment Utility
The 1,000 limit applies to how many records CR reads, not outputs. Thus, if there are a lot of dups, then it could read in 1,000 records and only print out 300 unique records.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
How to increase the row limit in Jasper Server.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…
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.

772 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

11 Experts available now in Live!

Get 1:1 Help Now