reporting-servicesparameters

Passing Parameters to a URL


Ok, been looking at examples and answers given for this problem and so far none of them have worked. I either get the parameters aren't being passed or an error.

I have an SSRS report setup where when the user clicks on a text box it should pass the CalendarID and the student number to the next report. When doing it with a report but not when I have it going to a URL.

Right now my URL looks like this

http://mpstasks1/ReportServer/Pages/ReportViewer.aspx?%2fMPS%2fStudent+Summary&rs:calendarID=@calendarID.value

I have 2 parameters I want to pass but testing with one right now.

What am I missing?

TIA


Solution

  • It sounds like your hard coding the entire string with the parameter, but the string would need to be created in the expression for the Go To URL to evaluate the parameter.

    ="http://mpstasks1/ReportServer/Pages/ReportViewer.aspx?%2fMPS%2fStudent+Summary&rs:calendarID=" & Parameters!calendarID.Value

    enter image description here