Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: Not all values appear in dynamic parameter Post Reply Post New Topic
Author Message
jbrandes99
Newbie
Newbie


Joined: 02 May 2011
Location: United States
Online Status: Offline
Posts: 17
Quote jbrandes99 Replybullet Topic: Not all values appear in dynamic parameter
    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?



Edited by jbrandes99 - 07 Jun 2011 at 8:25am
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet 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
IP IP Logged
Dewald
Groupie
Groupie
Avatar

Joined: 02 Jun 2011
Location: South Africa
Online Status: Offline
Posts: 47
Quote Dewald Replybullet 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
IP IP Logged
jbrandes99
Newbie
Newbie


Joined: 02 May 2011
Location: United States
Online Status: Offline
Posts: 17
Quote jbrandes99 Replybullet 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!
IP IP Logged
Dewald
Groupie
Groupie
Avatar

Joined: 02 Jun 2011
Location: South Africa
Online Status: Offline
Posts: 47
Quote Dewald Replybullet Posted: 09 Jun 2011 at 8:42am
What version of Crystal are you using?
Dewald Botha
http://www.ITClarity.co.za
IP IP Logged
jsuarez
Newbie
Newbie
Avatar

Joined: 05 Jul 2011
Location: United States
Online Status: Offline
Posts: 1
Quote jsuarez Replybullet Posted: 05 Jul 2011 at 6:08am
I am having the same issue as 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? 
 


Edited by jsuarez - 05 Jul 2011 at 6:16am
Thanks!
-J
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.