OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » Summaries total

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

Summaries total [message #140154]

Sat, 01 October 2005 08:03

kamran.it
Messages: 265
Registered: September 2005
Location: Karachi

Senior Member

I have 3 summary column A,B & C now I want to sum all these A+B+C in Oracle Report, how it can be possible ??

Report message to a moderator

Re: Summaries total [message #140160 is a reply to message #140154]

Sat, 01 October 2005 10:56

saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn

Senior Member

Hi,
Create a formula column in Data Model. Open property pallete of the Column, write PL/SQL formula as

  Return (:A + :B + :C);

Open Layout model, create a field, open property of the field, and under "source", bring the formula column name.

That's it.

Note: You should firt do it yourself. If not succeeded, then only bring your problems here. Read the sticky please.

Regards

Report message to a moderator

Re: Summaries total [message #142502 is a reply to message #140154]

Fri, 14 October 2005 23:24

kamran.it
Messages: 265
Registered: September 2005
Location: Karachi

Senior Member

I tried to apply this fuction but a error shows
"REP-1517: column 'CF_1' references column 'MDQTY', which has incompatible frequency."

Report message to a moderator

Previous Topic:	Printing with Oracle Report
Next Topic:	how to create matrix frame

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 01 03:39:01 CDT 2024