Solved

Crystal XI Dynamic Parameter Not Displaying All Available Values

Posted on 2010-08-20
5
818 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
[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
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 101

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

[Live Webinar] The Cloud Skills Gap

As Cloud technologies come of age, business leaders grapple with the impact it has on their team's skills and the gap associated with the use of a cloud platform.

Join experts from 451 Research and Concerto Cloud Services on July 27th where we will examine fact and fiction.

Question has a verified solution.

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

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…
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.
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

622 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