Re: Reports requirements -- Urgently needed

Hi Alan

This is no cross posting. I dont think non serious persons should post in this groups.

I actually transformed my problem so that you guys could understand it easily. You took it as some joke.

FYI, I got the answer.

Look at

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=70257.1

Thanks for responding.

Nave

"Alan" <alan_remove_this_shein_at_erols.com> wrote in message news:<ajttp3$1eabhb$1_at_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 Thu Aug 22 2002 - 15:24:17 CDT