| trying to calculate in a Report [message #334872] |
Fri, 18 July 2008 08:35  |
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 #336728 is a reply to message #336659] |
Mon, 28 July 2008 15:48  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
