Showing posts with label queryi. Show all posts
Showing posts with label queryi. Show all posts

Friday, February 17, 2012

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 ?