Hi,
ive 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 handle this.