use parameters in SQL Server reporting services with sharepoint lists


  • I want to make report from sharepoint 2010 list and forms library in sql server reporting services.

    but also want to apply parameters.

    I tried but parameters but it is not working.

    How I can apply sharepoint lists parameters in sql server reporting services ?

    How to run or view report of sharepoint lists or form library in sqlserver reporting services with required parameters?

    Tuesday, February 25, 2014 8:55 AM


  • Hi John,

    When we use SharePoint list as datasource in SSRS it has two method to add parameter. Suppose we have a dataset (DataSet1) get data from SharePoint list. Please refer to the methods below.

    Method 1: We can add parameter in the Query Designer dialog box to add parameter.

    1. Click “Add Filter” icon in the “Applied filters” dialog box in Query Designer.
    2. Select the corresponding field (Title), fill with specific conditions, and select Parameter option in the end of the row.
    3. Create a dataset (DataSet2) fill with Title field.
    4. Double click the parameter we create above, set the available values from DataSet2 field Title.
      (Note: In the situation, we are get the single-value parameter.)

    Method 2: It is a general method to add parameter in SSRS report.

    1.  Create another dataset (DataSet2) in the report fill with Title field.
    2. Add a parameter (Title) get available values from DataSet2 Title field.
    3. Add filter in the DataSet1.
      (Note: This method, we can configure multi-values parameter.)

    If you have any questions, please feel free to let me know.

    Alisa Tang

    Alisa Tang
    TechNet Community Support

    Wednesday, February 26, 2014 4:18 AM