Portal Sort problem Summary

[Jorgen]

Hi There,

 

Again a portal sort problem wich i can't fix.

I would like to sort a field (Summary - count total) from table 3.

In my layout (table 1) is a portal wich shows records from table 2

and a summary field (total of points) from table 3.

Table 2 and 3 are the same.

All 3 tables are connected to each other.

How can is sort the summary field on the total of points????

 

Regards Jörgen

[Techphan]

If you are displaying records and a COUNT (summary) field is counting each record (as one or as "present" - and each record has the same value), how would you SORT on this field?

 

I think the answer is you cannot. Maybe someone else can shed some different (and better) light on this. Perhaps if you post a little more information regarding your application someone can suggest a different method to achieve your results.

[Jorgen]

Thanks for the reply, i try to explain:

 

In my first table (Persons) are 2 fields:

Field 1: personnumber

Field 2: personname

 

In my second table (Personinfo) are 3 fields.

Field 1: personnumber

Field 2: points

Field 3: points Summary (=total of the Points field)

 

The third table is the same as the second table.

 

In layout 1 (=Persons table) i made a portal from the second table

with the fields:

personnumber from the second table

points Summary from the third table

 

The counts from the points summary are ok.

Now i would like to sort on the points summary in descending order.

 

I hope this wil make it clear

 

Thanks and regards Jörgen

[Techphan]

Right click the portal in layout mode and go to:

 

Portal Setup -> Sort Portal Records.

 

You can choose the field(s) to sort and the method (ascending or descending).

[Jorgen]

Hi,

 

The field points Summary (= total of points) is grey and cannot be sorted on

 

Regards JorgenOh Really!

[Techphan]

Mea culpa! You cannot sort on a summary field.

 

Make a calculated field and set it equal to the summary field. But I still do not see where that will benefit you. The summary field is a total of the scores and therefore is the same value in each record (similar to - but not the same as a global value).

 

 

For example (my exam scores in your mathematics class):

 

Rec.No.......Item Desc....Score..........Score (summary)

Record1.....Exam 1...........23.................86

Record2.....Quiz 1.............7..................86

Record3.....Exam 2...........19.................86

Record4.....Final Exam.......37.................86

[Jorgen]

Hello again: I will explain the background of my question why i want to sort on total of points:

It is about my database with Top40 hits in The Netherlands.

A song comes out in a certain week of a year. Every week it gets serveral points. Every week i collect the data.

After a certain amount of weeks the title leaves the Top 40.

Now, here it comes:

I tell my database to show all the titles of a year.

It shows all the titles of that year. It does not show 52 weeks with every week 40 records.

So it shows the title once in the portal. In that same portal it shows all the collected points of the weeks (total).

Now i want to sort on the titles with the most points and that's what i want.

Mostley the titles with the most points are the most famous.

 

My portal shows something like this:

1965 - Beatles - I feel fine - 16 weeks - 400 points

1965 - Roy Orbison - Pretty woman - 12 weeks - 600 points

1965 - Supremes - Baby Love - 8 weeks - 300 points

 

Now i would like to sort on the points.

 

A little more clearer?

 

Tns a lot

 

regards Jorgen

[Techphan]

Sort on the field that has the points (Beatles=400, Roy Orbison=600, etc), not on the summary field.

 

Perhaps you can post a sample of your database...

[Jorgen]

Hi Techphan,

 

For example (my exam scores in your mathematics class):

 

Rec.No.......Item Desc....Score..........Score (summary)

Record1.....Exam 1...........23.................86

Record2.....Quiz 1.............7..................86

Record3.....Exam 2...........19.................86

Record4.....Final Exam.......37.................86

 

In your example i will explain.

There are more records with Exam 1, Quiz 1 and so on.

Exam 1 has different scores, Quiz 1 too.

I do not have to see the different scores but i would like to see

just the total of these different scores and sort on that.

 

Jorgen