Home » Developer & Programmer » Reports & Discoverer » Grand Total in Discoverer Report shows zero
Grand Total in Discoverer Report shows zero [message #252179] Wed, 18 July 2007 01:34 Go to next message
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
Re: Grand Total in Discoverer Report shows zero [message #252308 is a reply to message #252179] Wed, 18 July 2007 09:57 Go to previous message
Anand Ramaswamy
Messages: 111
Registered: January 2005
Senior Member
My issue got resolved. It was because of wrong join criteria to another folder.

Thanks
Previous Topic: report is spread out in second page in oracle application
Next Topic: SRW.RUN_REPORT (REP-0091 Invalid value of parameter) help
Goto Forum:
  


Current Time: Thu Dec 08 08:44:48 CST 2016

Total time taken to generate the page: 0.11050 seconds