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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics