SSRS 2008R2 URL Report Parameters Ignored
Experts,
I access an organizational report that requires 2 parameters. I want to pass the values through the URL. In researching, I found the MSDN article below. It sounded straight forward; however, I cannot seem to get the parameters values to pass.
Passing a Report Parameter Within a URL
http://msdn.microsoft.com/
https://XYZ/ReportServer/Pages/ReportViewer.aspx?%2Area%2fSM_Penetration&rs:Command=Render&RptLevel=State&Area=R20
What am I doing wrong? Are there any server side settings that might be blocking (end user without access, but can request)?
Thanks!
I access an organizational report that requires 2 parameters. I want to pass the values through the URL. In researching, I found the MSDN article below. It sounded straight forward; however, I cannot seem to get the parameters values to pass.
Passing a Report Parameter Within a URL
http://msdn.microsoft.com/
https://XYZ/ReportServer/Pages/ReportViewer.aspx?%2Area%2fSM_Penetration&rs:Command=Render&RptLevel=State&Area=R20
What am I doing wrong? Are there any server side settings that might be blocking (end user without access, but can request)?
Thanks!
sammySeltzer
You didn't say if you are attempting to pass the parameters through reportviewer of your .net app or sql server reporting services.
Well, i don't see problems with the link ..are you getting an error when you use it..if so, can you post the error msg?
Also, i would like you to try access the report without passing the parameters in the URL.. just to make sure that its not related to security issues..
Also, i would like you to try access the report without passing the parameters in the URL.. just to make sure that its not related to security issues..
ASKER
No net app, just using SQL reporting services. I do not get any errors with the parameters added or removed. The report renders as if they weren't added (can manually select them and the report works fine).
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Ok.. I believe the value you are passing as a parameter is just not the right one.. What i mean is either of the values might not be right which can yield a result set.. I did face a similar problem before when i tried to pass a Value - "Area20" instead of "Area 20" in which case it was just ignoring the parameter value
ASKER
Sammy, that was the format that I followed with the exception of ".rdl" Whe I attempt to add that I get an error stating
...SM_Penetration.rdl' cannot be found. (rsItemNotFound)
vdr1: Prior to submitting the request, I confirmed that I had the correct parameter name and value. We even too another report with only a StartDate and StopDate, with the same result. Report renders but parameters not passed.
...SM_Penetration.rdl' cannot be found. (rsItemNotFound)
vdr1: Prior to submitting the request, I confirmed that I had the correct parameter name and value. We even too another report with only a StartDate and StopDate, with the same result. Report renders but parameters not passed.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Had the report developer confirm that I had the parameter names and case correct. Are there any SSRS setting that need to be enable in order for URL parameters to be accepted? Potential site trust issues?
Since you are able to access the reports without any security issues.. i believe "Site trust" isn't the problem and also i don't think there are any other settings that you need to change to access the URL parameters.. if there are any, the default settings accept the URL parameters.. if you think that is causing the problem then the developer should know what values he has changed while configuring SSRS.
Is it possible to attach the definition? so that we can take a look
Is it possible to attach the definition? so that we can take a look
ASKER
No way that I can attached the definition of the report. My developer spent about 3 hours trying to get this process to work and we even created a simple test report with only a startdate and stopdate to test. Still not luck...that why I posted here, trying to see if there might be some configuration setting that we might be overlooking.
Since I cannot post my report, I wondering if there might be a test location (beyond our corporate walls) that I could test out the process just to rule out some kind of access restrictions.
Apprciate all the help!
Since I cannot post my report, I wondering if there might be a test location (beyond our corporate walls) that I could test out the process just to rule out some kind of access restrictions.
Apprciate all the help!