CODEWITHSUNDEEP
reporting-services
John Ortega
John Ortega

Reputation: 41

SSRS DateTime Parameter in URL

I am passing the following URL in order to load a report in SSRS. There are two parameters in the report:

http://servername/Reports/Pages/Report.aspx?ItemPath=%2fReports%2fApplications%2fPersonnel%2fRptNameChange&ssn=#########&txtEffectiveDate=06/01/2012

Parameters

  1. String - ssn
  2. DateTime - txtEffectiveDate

However, when the page loads, it is as if the parameters are not recognized and it loads the page with empty fields in the parameters.

What is missing or incorrect about the URL? Thanks!

Upvotes: 3

Views: 5355

Answers (2)

John Ortega
John Ortega

Reputation: 41

I was calling the Report Manager URL, instead of the Web Service URL.

Here was the working version of the SSRS Url: http://servername/ReportServer?/Folder1/Folder2/Folder3/

In order to complete the call to the SSRS Web Service Url, attach the report name and any parameters that are needed to run the report:

http://servername/ReportServer?/Folder1/Folder2/Folder3/ReportName&Param1=12345

Upvotes: 1

Michael A
Michael A

Reputation: 9930

You're so close! You should be able to pull this off by changing Report.aspx to ReportViewer.aspx. For example, see below:

http://servername/Pages/**ReportViewer.aspx?**ItemPath=%2fReports%2fApplications%2fPersonnel%2fRptNameChange&ssn=#########&txtEffectiveDate=06/01/2012

Upvotes: 2

Related Questions