Re: Reports Aggravation

Thanks for all the suggestions.
I resolved the page footer issue thusly: The report as generated has a frame on the outside with a repeating frame for the first query group ( R_G_CUST_ID) inside it and then more frame and repeating frames inside it.
1) I created a frame around the page header stuff (which has always worked right) set to print each page fixed vertical. 2) I created another frame around all the "guts" of the report set to print each page fixed vertical.
3) I then created a third group inside R_G_CUST_ID (called M_PAGE_FOOTER) but not inside either of the groups I created in step 1 or 2. Set it to print each page, fixed vertical. 4) I put all my page footer items inside M_PAGE_FOOTER.

The change the sort dynamically suggestion was clever but doesn't solve my problem.
The data looks like
INV_NUM ITEM CATEGORY SUB_CATEGORY

1                    1     Cat1                Sub1
1                    2     Cat1                Sub1
1                    3     Cat1                Sub2
1                    4     Cat1                Sub2
1                    5     Cat1                Sub2
1                    6     A Cat2            Sub1

There should be SUB_CATEGORY breaks after row 2 and 5 and CATEGORY break after row 5.
<GRIPE>

I did this 10 years ago in COBOL class and for years in Clipper, Foxpro and then Powerbuilder but an advanced tool like Oracle Reports won't cooperate
</GRIPE>

Because I need sub-totals and white-space I need groups at CATEGORY and SUB_CATEGORY but when I do this the result set is re-ordered to INV_NUM ITEM CATEGORY SUB_CATEGORY

1                    6     A Cat2            Sub1


<= A Cat2 sorts before Cat1


1                    1     Cat1                Sub1
1                    2     Cat1                Sub1
1                    3     Cat1                Sub2
1                    4     Cat1                Sub2
1                    5     Cat1                Sub2