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

ssrs 2012 show hide parameter area Expand / Collapse
Author
Message
Posted Monday, December 09, 2013 3:55 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Saturday, April 19, 2014 4:39 PM
Points: 300, Visits: 342
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?
Post #1521334
Posted Tuesday, December 10, 2013 12:22 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:14 AM
Points: 12,228, Visits: 9,204
You can control this in SharePoint, but I'm not sure it is possible in Report Manager.
You can pass the URL access parameter if you build your own reporting webpage and you call the SSRS report through the URL.




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 #1521411
Posted Tuesday, December 10, 2013 7:57 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Saturday, April 19, 2014 4:39 PM
Points: 300, Visits: 342
I am not working with share point services so that is not an option.

I want to ask the following also:
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?
Post #1521535
Posted Tuesday, December 10, 2013 9:05 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Saturday, April 19, 2014 4:39 PM
Points: 300, Visits: 342
I also wanted to mention the following:
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?
Post #1521567
Posted Wednesday, December 11, 2013 12:26 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:14 AM
Points: 12,228, Visits: 9,204
Haven't done this myself, but I think you can use the "go to URL" option that you mentioned.
You can pass parameters to the URL:

Pass a Report Parameter Within a URL




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 #1521760
Posted Wednesday, December 11, 2013 7:59 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Saturday, April 19, 2014 4:39 PM
Points: 300, Visits: 342
The reference you pointed 'http://msdn.microsoft.com/en-us/library/ms155391.aspx' looks like a good link. My question is how is url suppose to obtain the value for the parameters? Do you know what syntax I would use?
Post #1521918
Posted Wednesday, December 11, 2013 1:43 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:14 AM
Points: 12,228, Visits: 9,204
wendy elizabeth (12/11/2013)
The reference you pointed 'http://msdn.microsoft.com/en-us/library/ms155391.aspx' looks like a good link. My question is how is url suppose to obtain the value for the parameters? Do you know what syntax I would use?


You can use an expression to build the URL. An example:

http://altecnotes.blogspot.be/2012/05/passing-parameters-to-ssrs-report-using.html




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 #1522048
Posted Wednesday, December 11, 2013 2:39 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Saturday, April 19, 2014 4:39 PM
Points: 300, Visits: 342
When I want to develop the ssrs report in the bids ide, what would I change the url to? I would think the url would be different when running the ssrs report on my workstation using bids.

Thanks for letting me know!
Post #1522065
Posted Wednesday, December 11, 2013 3:05 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:14 AM
Points: 12,228, Visits: 9,204
You cannot call a report in BIDS with an URL (you need a web service). You need to deploy the report to the server first and then you can access the report on the server with the URL.



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 #1522077
Posted Thursday, December 12, 2013 3:20 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Saturday, April 19, 2014 4:39 PM
Points: 300, Visits: 342
Thanks very much for your assistance!
Post #1522505
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse