SSRS Issue RRS feed

  • Allgemeine Diskussion

  • Dear all

        I am working in SSRS.I am trying to add the Filter in the Preview by creating a report parameter..Intiaklly it was coming but when i changed some code and its working fine in the "Data" tab.But when i am trying to open in the preview, its showing error after i select the value in the filter..


    An erroe has occurred during local report processing
    An erroe has occurred during report processing
    Query  expression failed for dataset <Datset name>
    Must declare the scalar variable @SalesPerson

    where i am doing wrong..please help me out..


    Freitag, 21. August 2009 12:04

Alle Antworten

  • Dear all

     i found out the solution for this..just cretae a new dataset and copy your code in the that new dataset and create a report parameters..
    Now go to preview and select the parameters u have given, now it will work..

    hope it will help you..


    Mittwoch, 9. September 2009 06:56