banjara15
asked on
Cascade parameter refresh
Hi,
I am working on a SSRS 2012 report and I need your help with this problem
The report has two parameters:
1) @Search is a text type param and has two specific values
- "WorkerId"
- "DepartmentId"
2) @ActCodeFilter is also a text type param and only 1 default value
- "%"
When report is executed the first param gets "workerid" as the default value and
the second parameter get "%" as the default value.
My requirement is when I change the value of first parameter to "DepartmentId" the second parameter value should become Blank i.e the text box should become empty.
Thanks for your help.
I am working on a SSRS 2012 report and I need your help with this problem
The report has two parameters:
1) @Search is a text type param and has two specific values
- "WorkerId"
- "DepartmentId"
2) @ActCodeFilter is also a text type param and only 1 default value
- "%"
When report is executed the first param gets "workerid" as the default value and
the second parameter get "%" as the default value.
My requirement is when I change the value of first parameter to "DepartmentId" the second parameter value should become Blank i.e the text box should become empty.
Thanks for your help.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.