SQL Server Performance

Executing Parameterised Stored Procedures

Discussion in 'SQL Server Reporting Services' started by Rep_Ser, Jan 7, 2004.

  1. Rep_Ser New Member

    Hello Friends,

    I am trying to create a report using a parameterised stored procedure. The procedure executes successfully in the Data tab when we select the Dataset by prompting for the parameter value, but in the preview page I get the following error- "This parameter is not a parameter for the stored procedure".

    Ravi
  2. satya Moderator

  3. Rep_Ser New Member

    Hi,

    No I am using a stored parameterised procedure in the SQL Server Reporting Services Beta version.
    However, I got thru the problem.

    What I was doing was taking the value of the report parameter same as the parameter in the query, this was giving me an error - " Forward referencing of parameters is not allowed".

    For this I created a new dataset which was given as a source to the report parameter and it worked.

    Any way thanxs to one and all.

    Bye,

    Ravi
  4. satya Moderator

    Glad it worked and appreciate for the interest to post the workaround.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page