Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to hide/view a SSRS report parameter control dynamically at runtime? Expand / Collapse
Author
Message
Posted Thursday, March 6, 2014 2:34 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, April 1, 2014 12:06 AM
Points: 4, Visits: 8
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
Post #1548116
Posted Thursday, March 6, 2014 2:42 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:34 AM
Points: 13,277, Visits: 11,066
I don't think this is supported out of the box in SSRS.
Are you using Report Manager or SharePoint to view the reports?




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1548118
Posted Thursday, March 6, 2014 4:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, April 1, 2014 12:06 AM
Points: 4, Visits: 8
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
Post #1548189
Posted Thursday, March 6, 2014 4:58 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:34 AM
Points: 13,277, Visits: 11,066
In that case I would write my own parameter selection boxes and call the report using an URL with the parameters supplied.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1548192
Posted Thursday, March 6, 2014 5:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, April 1, 2014 12:06 AM
Points: 4, Visits: 8
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
Post #1548209
Posted Thursday, March 6, 2014 5:29 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:34 AM
Points: 13,277, Visits: 11,066
That should be possible yes:

Hiding parameter area when viewing reports




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1548210
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse