0

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.

enter image description here

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.

Improve this question
4
  • A dependent cascading parameter is generally bound to a query that uses the parent parameter value as input. That way, when the parent changes the child will also reset. Commented Jul 16, 2024 at 17:41
  • @RossBush is there a way to implement it without creating a new query but rather using this existing one. Commented Jul 16, 2024 at 17:53
  • You have to use cascading parameters, how do you expect your users to able to edit the query? There is a good article here mssqltips.com/sqlservertip/4758/… which might help. Commented Jul 17, 2024 at 8:11
  • @AlanSchofield thank you for the link, it was/is helpful however i can't figure out how to link my two parameters - there is no way to add a code snippet to this and I'm not sure where i can say only pull order dates for a given season (specified) Commented Jul 17, 2024 at 21:07
Related questions
5
SSRS Parameters - Values from a query (parallelism)
0
SSRS reports using Report Parameter in two datasets
0
SSRS in VS2017 - query runs in Query Designer but doesn't display in report
Load 5 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.