Hi
My problem is i have a selection criteria in reports.Based on selection criteria i am displaying data.
Selection criteria contains different grouping levels(3 level, 2 level , 1 level).
For example 3level grouping report looks like this.
Site
lob
Bu
some data
2level grouping report look like this
lob
bu
some data
1level grouping report look like this
Site
some data
I am able to put all the above mentioned grouping levels in a single table control.Based on selection criteria i am hiding the required table row.Now the requirement is i need to put expandable/collapsable(toggle) property at all the grouping levels. I have acheived this at 3 level grouping i.e in the first case.But in the other two cases i am failing because i am hiding the respective table rows.
If i take 3 table controls, i am able to solve the above mentioned problem.
But i want to do it in a single table control.
Any solution ?
Thanks in advance