I want the report (using Oracle report 6i and Oracle 8i as database) group by Institute Name and getting the values for Total Students and WorkShops for that institute and also have to show the ranks for particular criteria of the institute based on the values of that criteria in all the institutes.

Problem is of ranking.

Report:

InstituteName Total Std (Criteria 1) WorkShop(Criteria 2)….
Value Rank Value Rank
Inst 1
Inst 2


I am using following two tables as shown below:

MONTHLYINSTADMINDETAILS-------Table Name
Name Null Type
------------------------------- -------- ------------------------------------------------------------
SERIALNO NOT NULL NUMBER(10)
INSTITUTEID NOT NULL VARCHAR2(6)
TOTALSTD NUMBER(3)
WORKSHOP NUMBER(3)
…..
……


INSTITUTES---Table Name
Name Null Type
------------------------------- -------- ------------------------------------------------------------
INSTITUTEID NOT NULL VARCHAR2(6)
INSTITUTENAME NOT NULL VARCHAR2(40)


For understanding of the problem you can see the following report;

Student Maths Science….
Marks Rank Marks Rank
Student A 78 2 45 2
Student B 60 3 73 1
Student C 98 1 45 2
---