We have a report in SSRS build using query designer that lives on top of data that comes from the data warehouse. The set up looks like this.

How do I restrict one column by another column. Only return orders dates for performances selected rather then the entire data set available for 20+ years.

I can’t select values in the dropdown because those are a list of hard coded values. I want to code it by previous variable/column.

Any thoughts are appreciated.

I should add that because the dataset is a data warehouse – cube, when I add a new dataset it doesn’t allow me to type I have to use query designer to create additional datasets and i still don’t know how to link the two.