For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
I have a rtf template that calculate sum by FUND_CODE, DEPTID and school and it works fine without dynamic header, that is, with static contents in header. But when I add dynamic ZZDEPT_DESCR in the header to show the department name in header and add @section in group by DEPTID, the total by school is displayed after each deptid change, that's not what I want. I still want that there is only one school total after all departments. Can someone tell me how to fix that?
This is the code for group by DEPTID: <?for-each-group@section:current-group();./A.DEPTID?><?sort:current-group()/A.DEPTID;'ascending';data-type='text'?><?sort:current-group()/A.FUND_CODE;'ascending';data-type='text'?><?sort:current-group()/A.PROJECT_ID;'ascending';data-type='text'?>
Thank you in advance for your help!
Shiying