Drill-down using "n" levels using a table?

How should i create a "n" levels drill-down report using a table based on MDX query?

I can only seem to use the visible or invisible based on a know number of levels ("columns in the table") what if i don't know that exact number? Or it is a unbalanced hierarchy?

I cannot use the Matrix because my columns are static and with two levels...

You can use show/hide recursive groups in a table based on parent child hierarchies.|||How do i use that option in SSRS 2005 ?

drill-down capabilities and security implementation across different levels of h

Hi,

How to create the in crystal reports having drill-down capabilities and security implementation across different levels of hierarchy?
For instance, they can create a report having billing and booking Qty. that can be drilled-down across time dimension. Different levels could be year, month, week etc. Security should be implemented in such a way that a particular group of users can see data only at the week level, second group of users can see data at the month as well as the week level and third group can see all three - year, month and week data.

Can anybody helpppp??

smithaHi

CR is just a reporting tool, if u implement the security feature in the database that is accessed by the report, then you don't need to bother about it in the reports.