Saturday, April 18, 2015

SSRS Report : the value expression for the query parameter refers to a non-existing report parameter

This is one nasty error which I've experienced many times. Finally got one solution for that.. Do view code of the rdl..Find the killer bug..and correct it... ex:

Only referring to the code will help..


            =Parameters!FromDate.Value
         
         
            =Parameters!ToDate.Value
         
       

Correct it to


            =Parameters!FromDate.Value
         
         
            =Parameters!Todate.Value
         
       

Whatever we do outside wont help...even if we remove all the parameters from query and redo again... :)

Thanks to this part of the report...

Hope this serves good for someone out there...

Happy programming guys!!
Regards,