Hi,
How can I sort rows on report by a different computed key under a GroupSection than the key used for that GroupSection?
I have a problem with sorting by GSB key at GroupSection CUST_CODE level. The report has GroupSections for MS/REGION/ASM and then for CUST_CODE. Now, the records are sorted by CUST_CODE as there will be three rows for each CUST_CODE for last three months and as it's overriding the order by clause used in the query.
The requirement is to sort by GSB instead of CUST_CODE. I have tried with MemoryBufferSorter, Sub Report and by diving the query to send each asm code. But, at the lowest level because of the GroupSection it's ordering by CUST_CODE only. If I create one more GroupSection for GSB under CUST_CODE it's displaying three individual records ordered by GSB. But, finally these three rows should be grouped by CUST_CODE.
This needs to be done urgently and appreciate your quick suggestions or help on this.
Thanks in advance....
Sharan
Here is the report how it looks after generation:
Now, it's ordered by CUST_CODE, which should by GSB.
TOTAL
CUST_CODE CUST_NAME Apr May June QTY GSB GM
-------------- -------------------------- -------------------- ------------------ -----------------
9KZ23 LOWES OF LAKE PAR 160 71.1 22.4 X X X X X X 160 71.1 22.4
9MX88 THE HOME DEPOT IN 259 65.8 14.6 X X X X X X 259 65.8 14.6
How can I sort rows on report by a different computed key under a GroupSection than the key used for that GroupSection?
I have a problem with sorting by GSB key at GroupSection CUST_CODE level. The report has GroupSections for MS/REGION/ASM and then for CUST_CODE. Now, the records are sorted by CUST_CODE as there will be three rows for each CUST_CODE for last three months and as it's overriding the order by clause used in the query.
The requirement is to sort by GSB instead of CUST_CODE. I have tried with MemoryBufferSorter, Sub Report and by diving the query to send each asm code. But, at the lowest level because of the GroupSection it's ordering by CUST_CODE only. If I create one more GroupSection for GSB under CUST_CODE it's displaying three individual records ordered by GSB. But, finally these three rows should be grouped by CUST_CODE.
This needs to be done urgently and appreciate your quick suggestions or help on this.
Thanks in advance....
Sharan
Here is the report how it looks after generation:
Now, it's ordered by CUST_CODE, which should by GSB.
TOTAL
CUST_CODE CUST_NAME Apr May June QTY GSB GM
-------------- -------------------------- -------------------- ------------------ -----------------
9KZ23 LOWES OF LAKE PAR 160 71.1 22.4 X X X X X X 160 71.1 22.4
9MX88 THE HOME DEPOT IN 259 65.8 14.6 X X X X X X 259 65.8 14.6