Parent >> Child Hierarchy in SQL Server 2008 Reporting Service with Operational Source
I followed the below articles and i could build the Parent child Hierarchy in SSRS 2008 using Relational Database Source.
If you are ok with this look and feel then you can follow this.
http://www.mssqltips.com/tip.asp?tip=1939
http://blogs.msdn.com/b/robertbruckner/archive/2008/10/14/using-analysis-services-parent-child-hierarchies-in-reports.aspx
There are 4 Steps need to be done to do the SSRS 2008 Parent Child Hierarcchy report with ODS Source
Step 1: Create Datasource Connection and Dataset
Datasource: [AdventureWorksDW]
SELECT DimEmployee.EmployeeKey
,DimEmployee.ParentEmployeeKey
,DimEmployee.FirstName
,ISNULL(SUM(SalesAmountQuota),0) AS SalesAmount
FROM DimEmployee
LEFT JOIN FactSalesQuota ON FactSalesQuota.EmployeeKey = DimEmployee.EmployeeKey
GROUP BY DimEmployee.EmployeeKey
,DimEmployee.ParentEmployeeKey
,FirstName
ORDER BY 4 DESC
