OraFAQ Forum: Reports & Discoverer » trying to calculate in a Report

Home » Developer & Programmer » Reports & Discoverer » trying to calculate in a Report (oracle reports 6i)

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

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?

Report message to a moderator

Re: trying to calculate in a Report [message #334873 is a reply to message #334872]

Fri, 18 July 2008 08:37

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?

Report message to a moderator

Re: trying to calculate in a Report [message #334919 is a reply to message #334873]

Fri, 18 July 2008 11:34

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Purpose and use of a placeholder column is described in Report Builder's documentation.

Report message to a moderator

Re: trying to calculate in a Report [message #336659 is a reply to message #334872]

Mon, 28 July 2008 09:50

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,

Report message to a moderator

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.

Report message to a moderator

Previous Topic:	How to change default report name
Next Topic:	Not sure if i am using lexical parameter properly

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 08:22:31 CST 2024