Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 Building Hierarchial Sql Reports using sql 2005 Reporting

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-08-30 : 10:36:20
Kaushik writes "Hi,

I am trying to build a Hierarchial report (Treeview type) in Sql 2005 reporting services. My database table has a parent child relation (i.e ID and ParentID), now i would like to display the data based on those relationship like Parent-Child-child....
Like a treeview.

I already build a master report and then a sub-report which i called from that master report record( which has child). But this is going to be a fixed level report.

But i want a endless level report as long a parent has child under him.

This same problem i faced in asp.net 2005 development. Where i want to display a we form just like i want to display it in the report..i.e multicolumn hierarchial grid type.

How can i do these ? Kindly help me

With Regards
Kaushik"
   

- Advertisement -