Re: Reports requirements -- Urgently needed

Victor,

I did nt mean the sentence to you. I apologize for my earlier reply

Thanks

Nave
"Victor Kolesov" <victor_at_prg.akhz.com.ua> wrote in message news:<1029934238.223983_at_proxy.avdis.donbass.com>...
> Hi
>
> You must manualy draw one repeat frame for school level which should
> enclose matrix groups (repeat down)
> and other one repeat frame for organization level which should enclose
> matrix groups and school (repeat down)
> Also use summary tools to create new sum column for each added level.
>
> --
> --
> ==========================================================-
> The Best Regards,
> Victor Kolesov
> ICQ # 54695039
> ==========================================================-
>
> "Nave" <naveen_ind_at_hotmail.com> ???????/???????? ? ???????? ?????????:
> news:fee154c2.0208200912.6e1f03c4_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.
> >
> >
> > I am using Oracle REPORTS 6i on Windows 2000. the database is ORacle
> > 9i.
> >
> > Thanks
> >
> > Naveen
Received on Fri Aug 23 2002 - 21:12:10 CEST