I have a report with fields, Event, CancelDate, Designation, along with other data pertaining to the Event field. I would like for the user to choose which event that they would like to see in the report. There is a large number of events so I would like to narrow down the number of events that the Dynamic Parameter displays for the user. If I could narrow it down to a date range and where the Designation = "X" that would be great. Is it possible to call a parameter within another parameter? Also, should I use a Command for this report?

 

Thank you for all of your help!