none
SSRS for Sharepoint 2010 List, Cascaded Parameter Dropdowns RRS feed

  • Question

  • Hi,

    I wish to generate SSRS report for Sharepoint 2010 List, and the report should have Cascaded Parameter Dropdowns. Is it possible without using Stored Procedure ?

    Tuesday, August 28, 2012 9:00 AM

Answers

  • Hi,

     Cascading parameter can be done in SSRS !

    First decide which is the parent parameter and then decide  the child parameter .

    In the dataset of the child parameter from which you get the values for the child add a filter of the parent parameter.

    1. In the child parameter query add a filter of ur paren parameter.

    Eg : parentname = @Parentname

    Or

    2. in dataset property of ur child dataset  - goto filters and add the filter.(For this you need the parent name in your child dataset)

    Thanks

    Esmari


    • Edited by Esmari Tuesday, August 28, 2012 11:26 AM
    • Marked as answer by Ankush Jain SP2010 Tuesday, August 28, 2012 11:59 AM
    Tuesday, August 28, 2012 11:25 AM

All replies

  • Hello,

    Follow the example below. It may help you to start with.

    http://blogs.msdn.com/b/performancepoint/archive/2011/08/18/using-reporting-services-in-sharepoint-integrated-mode-with-pps-2010-with-sql-server-denali-ctp3.aspx

    Tuesday, August 28, 2012 11:19 AM
  • Hi,

     Cascading parameter can be done in SSRS !

    First decide which is the parent parameter and then decide  the child parameter .

    In the dataset of the child parameter from which you get the values for the child add a filter of the parent parameter.

    1. In the child parameter query add a filter of ur paren parameter.

    Eg : parentname = @Parentname

    Or

    2. in dataset property of ur child dataset  - goto filters and add the filter.(For this you need the parent name in your child dataset)

    Thanks

    Esmari


    • Edited by Esmari Tuesday, August 28, 2012 11:26 AM
    • Marked as answer by Ankush Jain SP2010 Tuesday, August 28, 2012 11:59 AM
    Tuesday, August 28, 2012 11:25 AM