December 9, 2013 at 3:55 pm
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?
December 10, 2013 at 12:22 am
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.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 10, 2013 at 7:57 am
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?
December 10, 2013 at 9:05 am
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:
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?
December 11, 2013 at 12:26 am
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
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 11, 2013 at 7:59 am
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?
December 11, 2013 at 1:43 pm
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
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 11, 2013 at 2:39 pm
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!
December 11, 2013 at 3:05 pm
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.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 12, 2013 at 3:20 pm
Thanks very much for your assistance!
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply