Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Need Help with Reports 2.5
Hi,
I am kind of new to reports 2.5. I have a couple of questions.
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