OraFAQ Forum: Application Express, ORDS & MOD_PLSQL » Classic Report- Sum based on Condition

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Classic Report- Sum based on Condition (Apex 4.2, Oracle 11g)

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

Classic Report- Sum based on Condition [message #651100]

Wed, 11 May 2016 05:50

Xandot
Messages: 235
Registered: January 2014
Location: India

Senior Member

Hi All,

I have created one classic report and I want to calculate SUM of the column based on some conditions like:

only records which started as 'ASB%' only that records should consider as in SUM value.

Please help me out ?

Thanks
Xandot

Report message to a moderator

Re: Classic Report- Sum based on Condition [message #651107 is a reply to message #651100]

Wed, 11 May 2016 07:26

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.

Report message to a moderator

Re: Classic Report- Sum based on Condition [message #651115 is a reply to message #651107]

Wed, 11 May 2016 09:15

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

Senior Member
Account Moderator

I believe that you should switch to an Interactive Report. It does such things easily, with no programming at all. You'd just filter records you're interested in and summary value would reflect the new data set's values.

Doing the same in a Classic Report is - as far as I can tell - difficult as you'd have to do everything manually (i.e. write some code which would do the job). Note that your own "summary function" might get rather complex as it requires you to take care about report's current WHERE clause (does it depend on some parameters already?), pay attention to filter you'd apply (is it 'ASB%' every time? Will you filter only one column or many of them?) etc.

Shortly, I'm not sure that the final result is worth such an effort, knowing that there's an alternative - Interactive Report.

Report message to a moderator

Re: Classic Report- Sum based on Condition [message #651397 is a reply to message #651115]

Tue, 17 May 2016 05:19

Xandot
Messages: 235
Registered: January 2014
Location: India

Senior Member

Thanks Littlefoot.

Report message to a moderator

Previous Topic:	APEX 4.0 IMPORT does not copy PL/SQL PACKAGE
Next Topic:	LOV return all value if null SELECTED

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 03 00:29:45 CST 2025