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.
| Author |
Topic |
|
plightstone
Starting Member
2 Posts |
 Posted - 2010-12-04 : 21:20:31
|
| I want to pass a parameter that I've called Agency to an ssrs report. I give it an integer value of 268 just to test it though later on it will be a session variable. The same report works fine when I allow the user to input the value of Agency as a report variable from within the report. But, when I run it now as a passed variable it keeps saying that "The 'Agency' parameter is missing a value." My URL to call this is:<a href="https://my server/Reports/Pages/Report.aspx?ItemPath=%2fmy dns name%2fReports%2fIYSA%2frptVolunteerInfoNEW&rs:Command=Render&Agency=268" target="_blank" style="text-decoration: none">I have substituted above "my server" for the true one and likewise "my dns name" for the true one. Now, I also have a parameter named in the report of Agency and in the data sets use the filter of that field being "IN (@Agency)". For passing Agency as a variable instead of allowing the user to input it from within the report I have hidden the parameter set within the report.I know this sounds very convoluted but it's actually quite straightforward. I appreciate any help you can give me. I suppose it boils down to this: I believe I'm passing the parameter correctly. After all, what's hard about putting the ampersand and the parameter and value. What I am probably doing wrong is using Agency as a parameter within the report and setting it to invisible and then using that as a filter (In(@Agency)). Thanks! |
|
|
|
|
|
passing parameters from a url to ssrs report