Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2016 : Technical Questions
Message Icon Topic: Dynamic Cascading Promts using multiple tables Post Reply Post New Topic
Author Message
Tonyak74
Newbie
Newbie
Avatar

Joined: 24 Apr 2013
Online Status: Offline
Posts: 20
Quote Tonyak74 Replybullet Topic: Dynamic Cascading Promts using multiple tables
    Posted: 21 Nov 2019 at 12:13pm
I am trying to create a Dynamic Cascading Prompt.
I have a Class table that has ClassKey, ClassCode and ClassDescription and so on...
I have a Model table that has Classkey, ModelKey, ModelNo, ModelDescription etc...
I have added the Dynamic Cascading prompt to the report.
When I preview the report, It prompts me for the Class Description.
Once I select the Class description the ModelNo's all populate.
The problem I am having is that ALL ModelNo's in the Model table show up in the list not just the models where the Model.ClassKey = Class.ClassKey from the Class Description selected in the first parameter.
I am not sure how to get this to work.
Any assistance would be greatly appreciated.
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1514
Quote kevlray Replybullet Posted: 21 Nov 2019 at 12:51pm
I am assuming that the tables are joined in the same way (Model.ClassKey = Class.ClassKey) with an inner join.
IP IP Logged
Tonyak74
Newbie
Newbie
Avatar

Joined: 24 Apr 2013
Online Status: Offline
Posts: 20
Quote Tonyak74 Replybullet Posted: 22 Nov 2019 at 4:08am
That is correct
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1514
Quote kevlray Replybullet Posted: 25 Nov 2019 at 4:03am
I have not see this issue before.  I do not know what is causing it.
IP IP Logged
hello
Groupie
Groupie
Avatar

Joined: 05 Feb 2014
Online Status: Offline
Posts: 85
Quote hello Replybullet Posted: 18 Dec 2019 at 3:41am
Try adding 'select distinct' in the SQL statement.
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.