Print Page | Close Window

Dynamic Cascading Promts using multiple tables

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22838
Printed Date: 28 Apr 2024 at 12:15pm


Topic: Dynamic Cascading Promts using multiple tables
Posted By: Tonyak74
Subject: Dynamic Cascading Promts using multiple tables
Date 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.


Replies:
Posted By: kevlray
Date 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.

Posted By: Tonyak74
Date Posted: 22 Nov 2019 at 4:08am
That is correct

Posted By: kevlray
Date Posted: 25 Nov 2019 at 4:03am
I have not see this issue before.  I do not know what is causing it.

Posted By: hello
Date Posted: 18 Dec 2019 at 3:41am
Try adding 'select distinct' in the SQL statement.


Print Page | Close Window