Hi,

I need to know the steps to manually create a ssrs report with a drill down for the query from adventure works database usgin matrix. Can someone guide me through this.

The query is as follows:-

select PPC.name as cat,PPSC.name as subcat,year(SSOH.orderdate) as FinYear
,'Q'+convert(char(2),datepart(qq,SSOH.orderdate)) as FinQuarter,
sum(SSOD.UnitPrice * SSOD.OrderQty) as QuarterSum
from Sales.SalesOrderHeader SSOH
inner join Sales.SalesOrderDetail SSOD on SSOH.salesorderid = SSOD.salesorderid
inner join production.product PP on SSOD.productid = PP.productid
inner join Production.ProductSubcategory PPSC on PP.productsubcategoryid = PPSC.productsubcategoryid
inner join Production.ProductCategory PPC on PPSC.productcategoryid = PPC.productcategoryid
where year(SSOH.orderdate) between 2002 and 2003
group by PPC.name,PPSC.name,year(SSOH.orderdate),
'Q'+convert(char(2),datepart(qq,SSOH.orderdate))
order by PPC.name,PPSC.name,finyear,finquarter

and the output should be like a drill down for components showing sub categories and year showing the quarters

Regards
Prachin