Home » Developer & Programmer » Reports & Discoverer » trying to calculate in a Report (oracle reports 6i)
trying to calculate in a Report [message #334872] Fri, 18 July 2008 08:35 Go to next message
ora1980
Messages: 251
Registered: May 2008
Senior Member
Hi

I have a report displaying the name, salary, and actual
increment of an employee

select statement is

SELECT CUSNAME, SAL, SAL*0.57 AS RAISE FROM ECUS


i want to add another field in my report which basically
shows the salary after increment (that is, sal + sal*0.57)

but how do i do that? can anyone please explain/

should i use placeholder for that?
Re: trying to calculate in a Report [message #334873 is a reply to message #334872] Fri, 18 July 2008 08:37 Go to previous messageGo to next message
ora1980
Messages: 251
Registered: May 2008
Senior Member
ok, its just a matter of changing my sql in the data tab

if thats so, then what is the use of placeholder column?
Re: trying to calculate in a Report [message #334919 is a reply to message #334873] Fri, 18 July 2008 11:34 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Purpose and use of a placeholder column is described in Report Builder's documentation.
Re: trying to calculate in a Report [message #336659 is a reply to message #334872] Mon, 28 July 2008 09:50 Go to previous messageGo to next message
jaganerp@gmail.com
Messages: 63
Registered: April 2008
Member
you have to take one more formula column, in that formula column you have to do your calculation,
Re: trying to calculate in a Report [message #336728 is a reply to message #336659] Mon, 28 July 2008 15:48 Go to previous message
mikeverkimpe
Messages: 30
Registered: April 2007
Location: Belgium
Member
simply change the select statement so it has the new item as a database item

SELECT CUSNAME, SAL, SAL*0.57 RAISE, (SAL + (SAL*0.57)) NEW_WAGE FROM ECUS

then add the new column called new_wage to your report.

Kind regards,

Mike Verkimpe.
Previous Topic: How to change default report name
Next Topic: Not sure if i am using lexical parameter properly
Goto Forum:
  


Current Time: Sat Dec 10 22:45:16 CST 2016

Total time taken to generate the page: 0.14554 seconds