Print Page | Close Window

Not all values appear in dynamic parameter

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=13416
Printed Date: 20 Apr 2025 at 1:39pm


Topic: Not all values appear in dynamic parameter
Posted By: jbrandes99
Subject: Not all values appear in dynamic parameter
Date Posted: 06 Jun 2011 at 8:18am

I am trying to create a report with filters based on a SQL view. The view is working as expected. There are about 10k records that return. The problem I am running into is in the report itself. I am trying to add a dynamic filter and am not seeing all of the values that are included in the SQL query (only the first one). Does anyone have a suggestion?


Replies:
Posted By: hilfy
Date Posted: 07 Jun 2011 at 11:06am

There is a registry setting that will tell Crystal to show more rows.  I don't remember what it is off the top of my head, but I know it's been posted here more than once.  If you do a forum search, you should be able to find it.

-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: Dewald
Date Posted: 07 Jun 2011 at 11:50pm
When you have that many records. Try creating a cascading set ao patameters, that breaks it up into smaller sections.
 
 


-------------
Dewald Botha
http://www.ITClarity.co.za

Posted By: jbrandes99
Date Posted: 09 Jun 2011 at 3:31am
I haven't used cascading parameters before. Can you give me some details on how to accomplish that?
 
Thanks!

Posted By: Dewald
Date Posted: 09 Jun 2011 at 8:42am
What version of Crystal are you using?


-------------
Dewald Botha
http://www.ITClarity.co.za

Posted By: jsuarez
Date Posted: 05 Jul 2011 at 6:08am
I am having the same issue as http://www.crystalreportsbook.com/forum/member_profile.asp?PF=12598&FID=9 - jbrandes99 .  My cascade does not pick up all the options.  I get maybe 17 at the most. 
 
I am on Crystal 11.0.0.895
 
Any Suggestions? 
 


-------------
Thanks!
-J


Print Page | Close Window