Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 Analysis Server and Reporting Services (2012)
 ssrs 2012 show hide parameter area

Author  Topic 

jassie
Constraint Violating Yak Guru

332 Posts

Posted - 2013-12-09 : 17:52:53
In an existing SSRS 2012 application, there is an up or down area that appears sometimes in the paramneter area of the SSRS report. When I hover over the up or down arrow, the tooltip calls this the 'show or hide parameter area'. I have the two parameters set to be visible that can be accessed by the user in this ssrs report. I do not know how to control this arrow.

The best link I can find from a google search is: http://msdn.microsoft.com/en-us/library/ms152835.aspx. However I do not know what part of questiuon.

Thus can you tell me and/or point me to a reference that tells me how to control when this arrow appears when the ssrs report is running? Can you tell me how to control this show or hide parameter area arrow in bids 2008 r2 or bids 2012 and in ssrs 2012?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-12-09 : 22:35:13
see if this helps

http://blogs.msdn.com/b/jgalla/archive/2009/03/23/hiding-parameter-area-when-viewing-reports.aspx?Redirected=true

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

jassie
Constraint Violating Yak Guru

332 Posts

Posted - 2013-12-10 : 10:17:55
Thank you for this link. It is very helpful! However I have additional question to ask you which is:

This rendering problem is occurring in a dashboard ssrs 2012 application. The various ssrs reports are called by the action on the textbox properties and 'go to report' is how the various ssrs web pages are called. Thus can you tell me how to translate &rc:Toolbar=false on the url to the way the ssrs report is called? So I need to change the calls to the various ssrs reports to 'go to url' instead? If not, does the &rc:Toolbar=false on the url need to be placed on the report server itself? Can I use both options? Can you tell me what you think the best option would be?
Go to Top of Page

jassie
Constraint Violating Yak Guru

332 Posts

Posted - 2013-12-10 : 11:09:37
I also wanted to add the following to this question:
In an existing ssrs 2012 dashboard application, I would like to change the calls for the various reports from 'go to report' to 'go to url' instead. I would like to make this change since I want to pass the value since I want to pass the value of either &rc:Toolbar=false or &rc:Parameter=On. I want this to occur so the 'show hide parameter toolbar area' is displayed for the user by default.

When I saved the https value on way of the calls I got an encrypted value that looked like the following:

https://companyname.org/Reports/Pages/Report.aspx?ItemPath=%2fDashboards%2fSSRS_test_Main&ExecId=deoa1f655=aslf556.

I am assuming that there can be a url that will actually pass the parameter value that is not encrypted. Is this possible? If so, how can I decrypt the value? If this is not possible, how can I use the encrypted that is generated and still pass the extra parameter value I want to use? Does this need to be a server setting?
Go to Top of Page
   

- Advertisement -