[SOLVED] Regrouping a report with multiple groups

[peterbarth]

I'm a newbie and am having trouble with creating multiple copies of one report with multiple group levels and then trying to rearange the groupings. Everytime a try to adjust the groupings I lose everything below it. For example I have a report with payroll earnings grouped by location, division, department, employee and I'd like to make a copy and remove location and division groupings, but when I do I lose the department and employee groupings as well as eveything laid out in the group headers. Anyone know how to do this?

[mikegreen]

What do you lose? If you are referring to the list header/footers, I get that too and it sucks :-(  Not sure how to get around it, other than I copied the contents out and re-pasted them back..

How are you changing the groupings? If you do it via the query and not the page layout, I think it works better.

Regards,

Mike

[JGirl]

Mike is correct

If you change the report data items in the query rather than through the layout you should be able to maintain your groupings.

For example, if you have a report with a top level grouping of 'Year', and you take a copy of this report and want to change the top level grouping to something else like 'Country', i'd edit the query, and change the derivation of the 'Year' column to use 'Country' instead.  Then rename each of the year items in the query / dimensions and your groupings should be maintained....

J

[peterbarth]

Thanks for the responses. This is kind of what I fgured, but I was hoping I just missed something. This is so easy in other reporting products. Cognos support said they couldn't understand why this would be a big deal. I guess they don't write reports with elaborate group headers and footers.