Prev: Can't pass multiple parameters using URL syntax when toolbar hidde
Next: SSRS 2005 - How to do a multi-line comment field (email body opening) for email subscriptions? Would like to add some line feeds and carriage returns to the email body.
From: Thomas Malia on 31 Aug 2009 20:00
We've created an SSRS report that takes a parameter. We can run the report
using the RSViewer.aspx (note: where using SQL 2008). We can also add the
parameter to the URL with a value however it doesn't seem to set the
parameter when the report generates.

I'm phrasing it this way because, what we found was, if we mispell the
parameter name in the URL then we get an error that the ID is not a valid
parameter name. However, if we spell the parameter name correctly we don't
get any error but it does come up and say that we have to populate all
parameters before generating the report.

I've already been to the following blog and tried exactly what it says, with
the same results derscribed above:
https://blogs.msdn.com/prash/archive/2009/01/21/passing-url-report-parameters-to-reports-in-sharepoint-document-library-in-ssrs-2008.aspx

Unfortunately, I'm not at a place where I can copy the URL that I'm actually
using, but I can steal one from another post that I found at:
http://www.ureader.com/msg/115712932.aspx This post is old and from the MS
blog you would think that this issue was resolved with SSRS 2008. However,
I'm getting the exact same behavior this person described back in 2007. So,
the URL they had looked like:

https://www.mycompany.com/mysite/_layouts/ReportServer/RSViewerPage.aspx?RelativeReportUrl=/mysite/myDocumentLibrary/test.rdl&KeyDate=10/5/2007
Now, what's happening to us is, a URL like the above brings up the report
page but is still waiting for the parameter values to be popluated.In our
testing we tried misspelling the parameter so it might look
like:https://www.mycompany.com/mysite/_layouts/ReportServer/RSViewerPage.aspx?RelativeReportUrl=/mysite/myDocumentLibrary/test.rdl&KeyDate_NotCorrect=10/5/2007
When we do this we get an error that "KeyDate_NotCorrect" is not a valid
parameter. This suggests to us that the system is Trying to read the
parameters, but we can't figure out why it doesn't actually apply the
parameter valued passed.This has been extremely frustration.Any one have any
insite about this?THanks in advance.



 | 
Pages: 1
Prev: Can't pass multiple parameters using URL syntax when toolbar hidde
Next: SSRS 2005 - How to do a multi-line comment field (email body opening) for email subscriptions? Would like to add some line feeds and carriage returns to the email body.