plz give me a solution for this by using SSRS 2005
I have the one table that table structure and data like this
Name ParentID ID Type
----- --------- --- -------
IND Null 1 Country
US Null 2 country
UK null 3 country
HYD 1 4 State
ND 1 5 State
VZA 4 6 City
TNL 4 7 city
GNT 5 8 city
XYZ 5 9 city
I want the out put like this
IND ----------- HYD ------------ VZA
------------- ND ---------- BZA
------------- -- ----------- GNT
------------- -- ------------ XYZ
US --- ---
UK --- ----
How to make this arrangment in SSRS 2005 Reports by using Grouping or
any methodlgy to achive this.
Plz give me solution any body