Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Need Help with Reports 2.5

Need Help with Reports 2.5

From: <dwarakv_at_hotmail.com>
Date: 1998/05/11
Message-ID: <6j62vd$6ah$1@nnrp1.dejanews.com>#1/1

Hi,

   I am kind of new to reports 2.5. I have a couple of questions.

  1. I have created a report with number of columns and the values in them are for e.g.

   column1 column2 column3 column4

    1        15           18        100
    4        10           19         73
    6        17           33         57

I need to generate the totals for all the four column at the bottom which should read as

Total 11 42 70 230.

2) My second question is that I need to create a report which shows data for all the 12 months in a year. Suppose, I give in a date as a parameter(for e.g. 1st of May(05/01/98)), I should have values for the period from jan'98 to april '98 and 0 for may'98 to dec'98. I need to display all the 12 months or atleast the the preceeding two months and the following two months when I view/print my report.

    Mar                Apr              May               Jun
col A   B   tot   col A    B   tot   col A   B  tot    col A   B    tot
5       7   12     6       0    6     0      0   0      0      0     0
10      6   16     0       5    5     0      0   0      0      0      0


   I am totally clueless abt how I would tackle these issues. Can someone out there help me, please.

Thanks
Dwarak

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon May 11 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US