AnsweredAssumed Answered

Summary Report to show top 5 records

Question asked by tomo17 on Jun 20, 2011
Latest reply on Jun 28, 2011 by tomo17

Title

Summary Report to show top 5 records

Post

I am trying to get a report to summarise data based on age and gender then show the top 5 performers for each based on a points score.  I have been able to get the report to do the summary for age and gender but this shows all the records for the database sorted by age and gender.  i have been able to script so that it shows me only 5 records (omitting the rest) but for the whole database.  what i cannot seem to get is these two to work together so that i get records in the following report:

age: 10  Gender : Male

Student #1

Student #2 etc

Age 10 Gender  FeMale

Student #1

Student #2 etc

Age: 11 Gender Male

Student #1

Student #2 etc

I know i need to script but i am stuck!

can anyone help or point me in the direction to any links that will help??

thanks

Outcomes