how to pass parameters to the Stored procedures used in the Pivot table/Chart of Performance point server RRS feed

  • Question



     I have a requirement of getting records from the Database stored procedures into the Pivot table/Chart based on the input dates which are all the parameters to the Stored procedures.

     I can declare a parameter using SSRS reports .rdl files.

    Please let me know is there any methods to create report parmaters and give the values to the stored procedures based on the specific conditions..


    Thanks in advance.

    Friday, August 8, 2008 8:48 AM



    ODBC datasources cannot manipulate data based on the paramters. It can return only scalar values. Although Stored Procedures can be used as datasource with parameter being passed only for KPIs (that too not a dynamic connection string). Tabular/chart report cannot have SP as datasource for now.
    Monday, August 11, 2008 5:56 PM