P
Paul
Here is the problem.... I need the records to sort by Y1
and so on then when the sorting is complete they group by
the record number.
Therefore, it could possibly be
record5
Detail3 Y1=100
Detail4 Y1=95
Detail1 Y1=90
Detail2 Y1=89
Record3
Detail1 Y1=99
Record4
Detail2 Y1=98
Detail1 Y1=97
Because record5 has the largest Y value of 100 then inside
of record5 the detail is ordered Z-A
Next, Record3 has the next largest Y value of 99
Finally, Record4 has the least largest Y value of 98 then
sorted inside of record 4 Z-A
In the report I have rearranged the sorting/grouping to
Y1, Y2, Y3, Y4 (all descending) then record number
(header, footer) (tried ascending & descending). The
problem is that now the detail records are no longer
grouped. Each detail appears as a separate item with its
own header and footer.
The problem maybe solved if there is away to:
Sort by Y1, Y2 .... (keeping the details for specific
records together)
Then regroup after the sorting is done.
Any thoughts?
And always...
Thank you for any and all help,
Paul
and so on then when the sorting is complete they group by
the record number.
Therefore, it could possibly be
record5
Detail3 Y1=100
Detail4 Y1=95
Detail1 Y1=90
Detail2 Y1=89
Record3
Detail1 Y1=99
Record4
Detail2 Y1=98
Detail1 Y1=97
Because record5 has the largest Y value of 100 then inside
of record5 the detail is ordered Z-A
Next, Record3 has the next largest Y value of 99
Finally, Record4 has the least largest Y value of 98 then
sorted inside of record 4 Z-A
In the report I have rearranged the sorting/grouping to
Y1, Y2, Y3, Y4 (all descending) then record number
(header, footer) (tried ascending & descending). The
problem is that now the detail records are no longer
grouped. Each detail appears as a separate item with its
own header and footer.
The problem maybe solved if there is away to:
Sort by Y1, Y2 .... (keeping the details for specific
records together)
Then regroup after the sorting is done.
Any thoughts?
And always...
Thank you for any and all help,
Paul