locked
ReportViewer Not taking passing Parameters RRS feed

  • Question

  • User83170176 posted

    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?Cry

    Tuesday, August 2, 2011 11:00 PM

Answers

  • User83170176 posted

    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.

    <QueryParameter Name="@ParameterName">
    <Value>2011-01-01</Value>

    I change value to take from the parameter and it solved. Laughing \:D/ thanks

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, August 3, 2011 1:02 AM

All replies

  • User1845063199 posted

    Could you paste an extract of your procedure...

    Wednesday, August 3, 2011 12:38 AM
  • User83170176 posted

    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.

    <QueryParameter Name="@ParameterName">
    <Value>2011-01-01</Value>

    I change value to take from the parameter and it solved. Laughing \:D/ thanks

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, August 3, 2011 1:02 AM