Cascading parameters

Question

Hello Everyone,

I need help in setting up the right value for one of my parameters. I have got 2 parameters - P1 & P2.
P1 is a single select dropdown & P2 is a TextBox
With every change in the selection of P1, I want the relevant value to be set in P2 by default & then the user can change it if needed before hitting the "View Report" button.

I am unable to get this working. Can you please help me with this?

Thanks

Answer 1

Hi @harshjprogress,

As your title said that what you need is cascading parameters.

Cascading parameters provide a way of managing large amounts of report data.

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.

Here are two articles about cascading parameters tutorials for your reference.

add-cascading-parameters-to-a-report-report-builder-and-ssrs
cascaded-parameters-in-sql-server-reporting-services

If I misunderstand your issue, please incorrect me.

Regards，

Zoe

---

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.
Hot issues October