Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

passing parameters to ssrs through querystring

I have to pass 4 parameters to ssrs report, this is how my url looks

Response.Redirect("http://ups117850/rpt/Pages/Rept.aspx?ItemPath=%2feMaaS%2feMaaS&rs:Command=render&studentId=" + studentID + "&startdate=" + StartDate + "&enddate=" + EndDate + "&type=" + type);

studentid=1031

startdate=4/1/2011

enddate=4/30/2011

type=student

ssrs throws error 'parameters validation failed"

like image 514
GANI Avatar asked Mar 26 '26 11:03

GANI


1 Answers

I suspect the problem is in the StartDate and EndDate that you are passing. If these are actual DateTime values you may need to format the resulting string properly. Does the code below work any differently?

Response.Redirect("http://ups117850/rpt/Pages/Rept.aspx?ItemPath=%2feMaaS%2feMaaS&rs:Command=render&studentId=" + studentID + "&startdate=" + StartDate.ToString("s") + "&enddate=" + EndDate.ToString("s") + "&type=" + type);
like image 195
Jamie F Avatar answered Mar 29 '26 03:03

Jamie F



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!