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.

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?

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.

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.

when i pass 2 parameters other 3 parameters must be set as null Thanks,Do help full

where i need to write this =IIF(InScope("GroupName"), Fields!ColumnName.Value, Nothing) is it in Omit or any where else

where i need to write this =IIF(InScope("GroupName"), Fields!ColumnName.Value, Nothing) is it in Omit or any where else

where i need to write this =IIF(InScope("GroupName"), Fields!ColumnName.Value, Nothing) is it in Omit or any where else

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.

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

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