OraFAQ Forum: Reports & Discoverer » Addition Column Report 6i

Home » Developer & Programmer » Reports & Discoverer » Addition Column Report 6i

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

Addition Column Report 6i [message #117957]

Mon, 02 May 2005 02:43

weekend79
Messages: 198
Registered: April 2005
Location: Islamabad

Senior Member

I want to develop a 03 columns report.
02 columns form database (simple) but want the 03 non-database Col = Col1 * Col2
In the end want the total of col 03.

Please advise how to do it.
Almost forget these 03 Columns are in a child group.

Wishes
Jawad

Report message to a moderator

Re: Addition Column Report 6i [message #117979 is a reply to message #117957]

Mon, 02 May 2005 06:55

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Several options:
1. add the column in your query:

SELECT col1
     , col2
     , col1*col2 as col3
  FROM yourtable

2. Add a formula column

As for the sum: add a summary field.

Check Reports help for more info.

MHE

Report message to a moderator

Re: Addition Column Report 6i [message #118108 is a reply to message #117957]

Tue, 03 May 2005 02:33

weekend79
Messages: 198
Registered: April 2005
Location: Islamabad

Senior Member

Dear

thanks is worked.

Wishes
Jawad

Report message to a moderator

Previous Topic:	How to make landscape reports in reports 9i ?
Next Topic:	How can I draw shapes in oracle report builder 6 ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 16 20:49:14 CDT 2024