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 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply