Using parameters in URL access with SQL 2005 Reporting Services in Sharepoint Intergration mode
-
On a pre SP2 SQL 2005 reporting server I can place parameters within a URL such as:
On a post SP2 SQL 2005 Reporting Server using Reporting Services in Sharepoint Integration mode, documents are stored in a Sharepoint document library with different syntax, such as:
http://SharepointServerName/PathTo/site/DocumentLibrary/ReportName.rdl
I have not been able to figure out what the new systax for passing parameters inside the URL. I have tried the following:
arameters=False&ProjectCode=ABC">http://SharepointServerName/PathTo/site/DocumentLibrary/ReportName.rdlarameters=False&ProjectCode=HF-202E">&rc
arameters=False&ProjectCode=ABChttp://SharepointServerName/PathTo/site/_layouts/ReportServer/RSViewerPage.aspx?RelativeReportUrl=/site/DocumentLibrary/ReportName.rdl&Source=http%3A%2F%SharepointServerName%2Fsite%2FDocumentLibrary%2FForms%2FAllItems%2Easpx&DefaultItemOpen=0&rc
arameters=False&ProjectCode=ABC(and other things too).
Does anyone know the correct syntax for URL access to a (SQL 2005 post SP2) report while passing parameters in Sharepoint Integration mode (WSS3)?
Rob Fisch
-
I have resolved the issue I was having. For those with the same problem read on...
...Just like the pre-SP2 Reporting Services has both a report server (i.e. http://servername/reportserver) and a report manager (i.e. http://servername/reports), Reporting Services in Sharepoint Integration mode has two ways of viewing reports. Replacing the report manager are Sharepoint document libraries. However the report server is still accessible.
To find the URL to your Sharepoint integrated report server, open Sharepoint Central Adminstration --> Application Management --> Manage integration settings (under "Reporting Services"). The URL in the "Report Server Web Service URL" textbox is what you want.
Paste this URL into a web browser, navigate to a report, then add the parameters to the end of the URL as you would have in a pre SP2 Reporting Services server. It should look something like:
http://servername/reportserver?http%3a%2f%2fpath%2fto%2freport.rdl&rs:Command=Render&parameter=123
arameters=False&ProjectCode=ABC
arameters=False&ProjectCode=ABC
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply