How can one expand/collapse columns from the same row header?
I'm trying to expand/collapse columns from the same header row, but unsuccessfully.
I can do it if I have separate rows. For example, the following shows the fiscal year expanded and quarter 1 expanded and quarter 2 collapsed.
- Year 2011
- Quarter 1 + Quarter 2
Week
1 Week 2 ...
Hour worked
John Doe 200
150 40 40 50
Jeff Smith 220
100 30 30 120
This works fine, but a separate header row is required for each group that expands/collapses. I would like to only have one header row and do all the expanding/collapsing within that row as follows:
Hour worked - Year 2011 - Quarter 1 Week 1 Week 2 ... + Quarter 2
John Doe 200
150 40 40 50
Jeff Smith 220
100 30 30 120
However, when I try to do this, and make the quarter toggle based on fiscal year, I get the following error message:
"Toggle items must be text boxes that share the same scope as the hidden item or are in a scope that contains the hidden item, and cannot be contained within the current report item unless current grouping scope has a Parent."
Is there a way to accomplish this?
Thanks in advance,
Paul
December 23rd, 2010 1:10pm