Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

RE: Add "All" to a Dynamic Cascading Parameter

Status
Not open for further replies.
allyne

allyne

MIS
Feb 9, 2001
410
US
Hello,

I have a Dynamic Cascading parameter called @Locations That looks like this: Parent_Location>OR_Department>OR_Location This works fine.

I have a Static Parameter called @Group1 that has the values "Surgeon" and "Anesthesiologist"

What I would like to do is
If the user Selects "Surgeon" from @Group1 then the @Locations parameter looks like this Parent_Location>OR_Department>OR_Location>Panel_1_Primary_Surg
If the user selects "Anesthesiologist" from @Group1 then the @Locations parameter looks like Parent_Location>OR_Department>OR_Location>Anesthesiologist

I'm using SAP Crystal Reports 2016

Thanks for all your help!
 
Status
Not open for further replies.

Similar threads

JustMe24
  • Locked
  • Question
How to select from 2 rows in a table
Replies
1
Views
168
SoftwareRT
SoftwareRT
David Richardson
  • Locked
  • Question
Adding BLOB Fields to Reports in Crystal Reports Professional 8.5
Replies
7
Views
291
hilfy
hilfy
D
  • Question
Stored Procedure with no Parameters
Replies
1
Views
262
hilfy
hilfy
RoknRole
  • Locked
  • Question
Static parameter list of values limitation
Replies
1
Views
148
RoknRole
RoknRole
Maverick2021
  • Locked
  • Question
runtime error 20567 "page header/footer is larger than page"
Replies
0
Views
149
Maverick2021
Maverick2021

Part and Inventory Search

Sponsor

Back
Top