April 28, 2010 at 11:49 am
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
April 28, 2010 at 1:23 pm
Its better to do it using SQL Query than in reports..
Can you post some valid sample data and Few Insert Statements with Values and also your table structure to help you better
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply