Post reply

how to create cascading parameeters ssrs

  • May 8, 2010 at 12:07 am

    #220774

    how to create cascading parameeters in ssrs, any body tell me the steps

  • May 8, 2010 at 5:10 am

    #1164548

    Hi friend,

    Assume you have 3 parameters (P1,P2 and P3) and 3 Datasets (D1,D2 and D3 ) such that P1 is populated by D1 , P2 by D2 and P3 by D3. In the rdl Layout in the section were you are setting the available values for the Parameter, for P2 select Query option, the select the Dataset = D1 and the corresponding field which will be an input to Dataset 2 .

    Same way for P3 , select Query option, the select the Dataset = D2 and the corresponding field which will be an input to Dataset 3.

    Thanks & Regards,
    MC

  • May 8, 2010 at 6:52 am

    #1164553

    Hi,

    At the following link Cascading Parameters creation explained step by step.Download(free) it.

    http://www.4shared.com/video/T65M5ITS/sql_server_2005_reporting_serv.htm

  • May 9, 2010 at 10:43 pm

    #1164811

    only4mithunc (5/8/2010)

    Hi friend,

    Assume you have 3 parameters (P1,P2 and P3) and 3 Datasets (D1,D2 and D3 ) such that P1 is populated by D1 , P2 by D2 and P3 by D3. In the rdl Layout in the section were you are setting the available values for the Parameter, for P2 select Query option, the select the Dataset = D1 and the corresponding field which will be an input to Dataset 2 .

    Same way for P3 , select Query option, the select the Dataset = D2 and the corresponding field which will be an input to Dataset 3.

    Nice explanation...

    Pradeep,

    Your can cascade parameters in your underlying SQL Query

    Raunak J

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply