How to chain parameters in Report Builder 3.0

Question

Hi all,
Is there a way to chain parameters in Report Builder? If for instance, the report has a parameter by state and another parameter for county, I want to only see the data in the county listbox for the selected state and not all counties for all states. I was thinking to modify the query for dataset for county to say a.state = b.state and a.countyid = b.countyid. Would this work?

Thank you,

Seyed

Answer 1

Hi @S G ,

Has your issue been resolved?

If you have any question, please feel free to let me know.

Best Regards，
Joy

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our [documentation][1] to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi @S G ,

Do you want to add cascading parameters to the report?
Cascading parameters provide a way of managing large amounts of report data. You can define a set of related parameters so that the list of values for one parameter depends on the value chosen in another parameter. For example, the first parameter is independent and might present a list of product categories. When the user selects a category, the second parameter is dependent on the value of the first parameter. Its values are updated with a list of subcategories within the chosen category. When the user views the report, the values for both the category and subcategory parameters are used to filter report data.
You can refer to: Add cascading parameters to the report (Report Builder and SSRS)
Regards,
Joy

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

Hi Joy,
Thank you for the answer. I will follow-up with the instructions and let you know if I have any questions.

Seyed

Answer 4

Hi @S G ,

The error suggest that the query is not well formed to be run in Oracle.

I would suggest you to :

1. Check the query see if it could run locally in Oracle.
2. Have you set the parameter in dataset setting? In this query for dependent parameter, you need to specify the query parameter to equal to report parameter.Associate a Query Parameter with a Report Parameter (Report Builder and SSRS)
   Best Regards,
   Joy

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 5

Which data provider are you using? Not every one supports named parameters, here you have to use the question mark ? instead.

SELECT ST 
FROM THUNDER.GGSALES
WHERE (REGION = ?)