Reputation: 1668
I am trying to create a URL link for a report and pass in a date parameter.
The report has an InDate
parameter that maps to a dropdown populated by a SQL query. The query returns a datetime (value) and an expression (label) that outputs the date value in a {month}
-{year}
format. Actual label values that appear in the dropdown are "Jun-2012","Mar-2012", etc. The InDate
parameter is also used as an input to drive two other date dropdown lists.
The current iteration of the report URL is as follows:
dadsql04/ReportServer/Pages/ReportViewer.aspx?%2fRED+Data+Warehouse/RRMemo&rs%3aCommand=Render&rc%3aParameters=false&InDate=06/30/2012
When I load the URL I get the following error message:
The InDate
parameter is missing a value
I have tried using different values for the InDate
parameter, escaping the slashes, etc. and nothing seems to work. Any help or code sample would be appreciated.
Upvotes: 3
Views: 9733
Reputation: 1668
It turns out the problem was that the InDate parameter was defined as a string instead of a datetime value. Once the parameter was changed from string to datetime the URL worked without an issue.
Upvotes: 1
Reputation: 17693
Date parameter format looks good, but the URL you're trying to use is referencing the Report Manager component.
Use this URL to query the report web service directly:
http://dadsql04/ReportServer?/RED+Data+Warehouse/RRMemo&rc:Parameters=false&InDate=06/30/2012
Upvotes: 0