March 6, 2014 at 2:34 am
Hi,
I am using SSRS 2005. I want to enable/disable or hide/view parameters based on another parameter selection.
Say Suppose I have 5 parameters. User selects first value in first parameter I should show only Second parameter and hide remaining 3 parameters (Parameter 3,Parameter 4 & Parameter 5).
If user selects second value in first parameter I should show third parameter and hide remaining 3 parameters(Parameter 2,Parameter 4 & Parameter 5).
Similarly If user selects third value in first parameter I should show fourth and fifth parameter and hide remaining 2 parameters(Parameter 2 & Parameter 3).
There is no relationship between these parameters except user selection.
I can not see any Visible property for report parameters.
Any "builtin" support in SSRS for this scenario.
Appreciate your help.
Regards,
Bala
March 6, 2014 at 2:42 am
I don't think this is supported out of the box in SSRS.
Are you using Report Manager or SharePoint to view the reports?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 6, 2014 at 4:56 am
Thanks for Reply.
RDL is deployed in Report sever and the Report is integrated with .net application. End user view the Reports from Application.
Regards,
Bala
March 6, 2014 at 4:58 am
In that case I would write my own parameter selection boxes and call the report using an URL with the parameters supplied.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 6, 2014 at 5:24 am
Thanks for the tips.
So I want to create an independent web page in .net that has the entire parameters section and then a submit button that calls the report with the selected parameters.
From SSRS side, I want to hide the parameters statically and make default values as NULL.
Can I achieve Show/Hide parameter functionality by this way?
Regards,
Bala
March 6, 2014 at 5:29 am
That should be possible yes:
Hiding parameter area when viewing reports
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy