APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Total Sum after report rows

handwerk.netNov 1 2009 — edited Apr 10 2012

Dear friends,

i need help to create a report with a total sum of some columns.

My select is:

Select col1,col2,col3,col4 from table;

The report will show all rows for these columns. That's ok.

But col3 and col4 are columns with amount of time used and time planned, so i want to show after all rows (in the pagination area or after) the sum of col3 and the sum of col4.

Perhaps looks like:

col1 col2 col3 col4
12.12.2009 Name1 5.0 3.0
12.12.2009 Name2 4.0 2.0
12.12.2009 Name3 3.0 1.0
1-3 next
12.0 6.0

(The sum values must placed among col3 and col4)

It is possible ?

Regards

Frank

Edited by: handwerk.net on Nov 1, 2009 9:34 PM