CREATE REPORT WITH 3 LEVELS OF SUMMATIONS

Gor_Mahia

Hi,

I've a query as below and i want to create inner most sum of category, then summing of DEPT then finally the sum of STATES

SELECT CATEGORY,GROUP_MEMEBRS,WORK_TITLE,DUE_AMT, PERIOD_YEAR,DEPT,STATE_NAME FROM MASTER_T

USING bi publisher 11.x + ms word API to create the rtf file.

any suggestion on how to resolve this.

Gianni Ceresa

Posting multiple time isn't going to make it any better and is against the rules of the community. Nobody in here is paid to look after threads and reply, it's a community effort: if somebody has something to reply, they will, without reposting again the same thing.