Re: Reports requirements -- Urgently needed

From: Jan Gelbrich <j_gelbrich_at_westfalen-blatt.de>
Date: Wed, 21 Aug 2002 09:48:19 +0200
Message-ID: <ajvgqj$1ejc42$1_at_ID-152732.news.dfncis.de>


Hi Naveen,

reading your post gives me an impression that you did all your work _only_ by using the report wizards
(did you ?). The report wizards are good for the basics, but very often reports are refined by manual add-ons
in the data model.

You can add CFs (Column Formula fields) to a group and enter a PL/SQL-Formula e.g. for a total you want. Goto "data model", choose View-Tools, and then you would coose the symbol with a +.
And in the Layout Model You would show them in a new Field (take care of repitition frames)

Hope it helps You

Jan

"Nave" <naveen_ind_at_hotmail.com> schrieb im Newsbeitrag 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 Wed Aug 21 2002 - 09:48:19 CEST

Original text of this message