How to Create ChildGroup for grouping data in SSRS

Yes, Last article we seen how to get the data using parametarized sql query now we see query wise also

YearWise--Quarterwise(default hide)---SalesAmount.

Now i want generate quarter wise also but not default ( Bydefault -need to hide).

Step add new parameter --Quarter:  every year has 4 Quaters i added as hardcoded values

Bydefaut i need Yearwise report.then quarter wise also so i need to create a Child group to Parent group( CalenderYear wise grouping: Pervious article).

for creating a child group

Now

 

output

till now we seen our Paramters(@Year, @Quarter) are hardcoded as

now some time we don't know input parameter value then need to get it as dynamic***  create a dataset.(DST_Month)

select distinct EnglishMonthName,MonthNumberOfYear from DimDate

Order by MonthNumberOfYear

Create a Parameter : Month. append this Dataset for data to this parameter.

now we added. need to change existing dataset(DSR_Parameters)--Query where condition 

WHERE        (DimDate.CalendarYear = @Year and DimDate.CalendarQuarter =@Quarter and DimDate.EnglishMonthName=@Month)

if your @Month accepts multiple parameters then

WHERE        (DimDate.CalendarYear = @Year) and (DimDate.CalendarQuarter =@Quarter) and DimDate.EnglishMonthName in (@Month)

check existing Dataset(DSR_Parameters) 

ad this parameter to report using DSR_Parameter dataset Parameter collection

then output: