Cascading Dynamic parameters

Hello,
Please find attached the screen shot of the tables involved.
The NtoNlist table is connected to physican and activefacilitylist using left join on the phnpi and the facid.
The report requires such that when I select a facility or multiple facilities as the facility parameter it should populate a cascading prompt which has only physicians who are in the nTonList.
Please help.
Not sure how to create it as a cascading parameters or any other work around.
screenshot.gif
Star79Asked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
Create a new parameter
Give it a name
Select data type
Set type to dynamic
Click in the left column and select the first field (Facility)
Click the next line select the second field  (Physician)

mlmcc
0
 
mlmccCommented:
Change the joins to INNER

mlmcc
0
 
Star79Author Commented:
I made the join to inner join for NtoNlist on Activefaciltylist and NtoNlist on Physician.
How to implement the cascading parameter ?
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
Star79Author Commented:
Facility is from activefacilitylist and phnpi should be from which table while creating the parameter
0
 
mlmccCommented:
You choose the fields you want the user tosee and select from.  The linking fields don't come into it.

mlmcc
0
 
Star79Author Commented:
what should the selection formula be
0
 
mlmccCommented:
What do you mean?

{FacilityField} = {?FacilityParameter} AND {DoctorField} = {?DoctorParameter}

Change those to match the names of the fields and parameters


mlmcc
0
 
Star79Author Commented:
hello mlmcc appreciate your thoughts..but is there any alternative to cascading parameter
0
 
mlmccCommented:
You can use 2 parameters but then they won't be limited to related values

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.