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

Home -> Community -> Usenet -> c.d.o.server -> Re: Reports requirements -- Urgently needed

Re: Reports requirements -- Urgently needed

From: Alan <alan_remove_this_shein_at_erols.com>
Date: Tue, 20 Aug 2002 13:20:35 -0400
Message-ID: <ajttp3$1eabhb$1@ID-114862.news.dfncis.de>

  1. You are cross-posting.
  2. Just post the professor's email address, and we'll send him the answer directly.

"Nave" <naveen_ind_at_hotmail.com> wrote in message news:fee154c2.0208200911.7757cb4b_at_posting.google.com...
> Hi All
>
> I have a report requirement. The problem is like this.
>
>
> There is an organization under which there are several schools.
>
> each school has different classes.
>
> Each class has several no of students.
>
> We have to display marks of all the students in each class of the
> organization (note. all classes, schools)
>
>




> Organization
>
> School1
>
> Class1 subject 1 subject2 subject3 Totals
>
> stud1 30 50 70 150
> stud2 40 70 90 200
> total for class 70 120 160 350
>
> Class2
>
> stud11 50 60 80 190
> stud12 70 80 90 240
> total for class 120 140 170 430
>
> total for school1 190 260 330 780
>
>
> like wise for another school
>
>
>
> Total for
> organization 190 260 330
> 780
>



>
> I have tried using the matrix report with groups. But i was able to
> create a matrix and find the totals upto the class level which is
> quite simple.
>
> I was not able to find the totals subjectwise for the school and
> orgnization levels.
>
> Can you suggest me any solution for this?
>
> Please ignore some formatting. It is the best I could fit in this
> compose text.
>
> but you should get the idea.
>
> Thanks
>
> Naveen
Received on Tue Aug 20 2002 - 12:20:35 CDT

Original text of this message

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