Solved

Crystal XI Dynamic Parameter Not Displaying All Available Values

Posted on 2010-08-20
5
806 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
ID: 33486277
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
ID: 33486679
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
ID: 33488444
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
ID: 33490448
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
ID: 33491866
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

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…
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

867 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

19 Experts available now in Live!

Get 1:1 Help Now