Problem with Drill Through Linking for Implementing Tree view Structure

Hai Iam new to SSRS 2005, please help me regarding below Drill Through Report Problem. Assum my problem with below example.Iam tried Hard iam not able to find the solution, Any body please help me.my real time problem is same as below functionality

If Suppose iam dispalying two columns like Country,Department,iam taking these two columns in a table, assume country column having America,south africa, individual america column having Florida state, south africa column contains capetown state, in the preview of the report iam applying drilldown to America column like + America, i need when clicking the America column i want to display Florida state under the column of Country like tree view structure

i need output like this and the same time i want to display other columns those also contain tree view structure assume other one is department column, with contains computers and sales, individualy computers contains HP, Sales contains Bikes

Country Department

+ America + Computers

--Florida -- HP

+ SothAfrica + Sales

--Capetown __Bikes

How to implement above output using drill through functionality, i tried with subreports and used all grouping formats, is possible for display output like above explain the procedure .

Thanks In advance

Jacks

Hi,

If Suppose iam dispalying two columns like Country,Department,iam taking these two columns in a table, assume country column having America,south africa, individual america column having Florida state, south africa column contains capetown state

From your description, you want to display other columns those also contain tree view structure assume other one is department column, right?

Actually you can build a tabular table by using Report Builder Wizard, and make your table structure to be a parent-child format, in that way, you can use inner join in your select statement, and put corresponding fields to Groups, Fields, Details. Thanks.

Thanks.

|||

Hai, iam new to reporting services please help me,

where can i see reportbuilder wizard in reporting services, can you please explain step by step procedure for creating parent- child Tabular format using report bulider wizard.

give repaly as early as possible

Thank you so much

Jack vs

|||

Hi,

Start your Visual Studio, and create a new project, choose the Business Intelligence Projects type, and click on "Reporting Service Project Wizard template".

In this way, you can modify the database connections, select queries, and table structures in an ease way.

Thanks.