locked
how to passs parameters dynamically RRS feed

  • Question

  • Hi,  Experts

     

     Please help me in this,

     

     

     

    I Have a Drill through report of type Matrix   that displays the sum of price 

     

    which is having two row groups and 3 column groups 

     

    row group parent group is Productcatagiry and child group is product name

     

    column group parent group is Year child group is Quarter another child group on Quarter is month

     

    I have another Report  of tablar which displays the details of the products,this  connected to the drill through report and having 5 parameters named

     

    1. Productcatagiry

     

    2.product Name

     

    3.year

     

    4.Quarter

     

    5.Month

     

     

     

    What i need is ,if i click on the corrosponding cell of  with out expanding the productcatagiry and year then it needs to pass the these two parameters only to the details report

     

    and if i expand the productcatatagiry with out expanding the year then it needs to pass these three parameters productcategiry ,productname and year to the details report

     

    and if i expand both product categiry and year then it needs to pass the corresponding four parameters including Quarter to the detail report

     

    and if i expand the Quarter also then it needs to pass the 5 parameters including month also to the details report .

     

    I already set the the default values of the parameters in details report as null but it is giving correct results for low level data that is having all the 5 parameters but not for other type like 2 parameters or 3 parameters and 4 parameters.

     

    Thanks in advance.

     

     

     

     

    Saturday, May 28, 2011 7:41 AM

Answers

  • Hi,

    You need to writ the expression when you are assing values to the drill through report parameters in the Main Report.

    I mean for the cell when you will check the action tab and give the drill through report.

    Hope its clear....


    Pavan Kokkula Tata Consultancy Services.
    • Proposed as answer by Eileen Zhao Monday, May 30, 2011 6:30 AM
    • Marked as answer by Haz.vali Monday, May 30, 2011 3:22 PM
    Monday, May 30, 2011 4:54 AM

All replies

  • It seems to me that the detail report has 5 parameters. When you intend to pass only 2 parameters, how are you expecting the other 3 parameters to be passed?
    Saturday, May 28, 2011 12:32 PM
  • Hi,
    To achive it you need to do changes in the Report Design and Query Dataset too. 
    In the Main report while you are passing the values to the drill through report you need to check the group level and should pass the appropiate values.
    For this you need to use the Inscope function.
    =IIF(InScope("GroupName"), Fields!ColumnName.Value, Nothing)
    In the detail (drill through) report for all the parameter check Allow Null check box.
    In the detail report dataset change the where clause as 
    WHERE (@Parameter1 IS NULL OR Column1 = @Parameter1)
    AND (@Parameter2 IS NULL OR Column2 = @Parameter2)
    ....
    Hope its clear & helpful....

    Pavan Kokkula Tata Consultancy Services.
    Sunday, May 29, 2011 4:17 PM
  •  

    when i pass 2 parameters other 3 parameters must be set as null 

     

    Thanks,Do help full

    Sunday, May 29, 2011 4:58 PM
  • where i need to write this =IIF(InScope("GroupName"), Fields!ColumnName.Value, Nothing)

    is it in Omit or any where else 

    Sunday, May 29, 2011 5:22 PM
  • Hi,

    You need to writ the expression when you are assing values to the drill through report parameters in the Main Report.

    I mean for the cell when you will check the action tab and give the drill through report.

    Hope its clear....


    Pavan Kokkula Tata Consultancy Services.
    • Proposed as answer by Eileen Zhao Monday, May 30, 2011 6:30 AM
    • Marked as answer by Haz.vali Monday, May 30, 2011 3:22 PM
    Monday, May 30, 2011 4:54 AM
  • Hi,

     

         I have a suggestion, Right click on the column group text box, and pass the desired parameters. For example if you consider the textbox having productcategory, then pass reportitems!textbox1.value for product category parameter and the year value from the textbox where the column group for year is added and keep the other as null. Repeat the same for all the cells.

     

    Please note, I havent tried out this solution. Its just a suggestion.

     

    Regards,

    Bharath

    • Proposed as answer by Eileen Zhao Monday, May 30, 2011 6:32 AM
    Monday, May 30, 2011 6:30 AM
  • I tried with your answer , but its not working

     

    For ProductCatagiry parameter in the expression what i wrote is  =Fields!ProductCatagiry.Value

    For year parameter in the expression what i wrote is ==year(Fields!Mdate.Value)

    For Productname parameter in the expression what i wrote is =IIF(InScope("Group1"), First(Fields!ProductName.Value, "MAIN"), Nothing)

    For Quarter  parameter in the expression what i wrote is =IIF(InScope("Group2"), DatePart("q",Fields!Mdate.Value), Nothing)

    For Month parameter in the expression what i wrote is  =IIF(InScope("Group3"), month(Fields!Mdate.Value), Nothing)

     

    Please do help full

    Monday, May 30, 2011 3:44 PM