Last post Aug 03, 2011 01:02 AM by casper_user
Aug 02, 2011 11:00 PM|casper_user|LINK
I have the ssrs report which accept the date range parameter. From the application, the date value is passed to the report. But the report result showing for different date. Tracing from sql profiler, the date passing to store procedure is different.
For example. date value from application is 2011-08-03(Value from calendar format to "yyyy-mm-dd") but the stored procedure is called with the date value '2011-01-01'.
Trace from application, when the parameter is set to reportviewer at reportViewer.ServerReport.SetParameters, the value is '2011-08-03' yet it called store procedure with '2011-01-01'. No matter what value i pass, it always call with '2011-01-01'.
Check from http://localhost/Reports there is no default parameter. what goes wrong with that ya?
Aug 03, 2011 12:38 AM|Gayomard Mehta|LINK
Could you paste an extract of your procedure...
Aug 03, 2011 01:02 AM|casper_user|LINK
Hi Thank for your post. I just solved the problem. I found the report have set that value. But I don't know why I can't see it from reportsserver.I use 2005 report server. I found this piece of code from the report code.
I change value to take from the parameter and it solved. \:D/ thanks