OraFAQ Forum: Reports & Discoverer » Grand Total in Discoverer Report shows zero

Home » Developer & Programmer » Reports & Discoverer » Grand Total in Discoverer Report shows zero

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Grand Total in Discoverer Report shows zero [message #252179]

Wed, 18 July 2007 01:34

Anand Ramaswamy
Messages: 111
Registered: January 2005

Senior Member

Hi All,
I created a discoverer report which shows Salary Amt, Travel Amt for each employee, period. I wanted to show the total salary cost & total travel cost in the last row.
When I use the Grand Total under Tools > Total (sum or cell sum), the last row always shows zero.
Any ideal why it happens and how it can be handled?

The folder query is:

SELECT EMPLOYEE_NUMBER, PERIOD_NAME, 
SUM(NVL(SALARY_AMT,0)) AS SAL_AMT, 
SUM(NVL(TRAVEL_AMT,0)) AS TRAVEL_AMT, 
'USD' as currency
FROM
( SELECT EMPLOYEE_NUMBER, 
   PERIOD_NAME, 
   DECODE(CATEGORY, 'SALARY', PERIOD_NET_USD) AS SALARY_AMT,
   DECODE(CATEGORY, 'TRAVEL', PERIOD_NET_USD) AS TRAVEL_AMT
  FROM APPS.DISC2_GL_JE_CONSOLIDATE_ORG )
  GROUP BY EMPLOYEE_NUMBER, PERIOD_NAME

Thanks in advance.
qA

Report message to a moderator