Summary in a portal

[Garu]

Hi, is it possible to display summary in a portal?

Assuming I have the following records:

Name    Company

Peter     A

John      B

Paul       C

Mary      A

I'd like to display the summary in a portal this way:

Company   Count

A                   2

B                   1

C                   1

Is that possible?

[comment]

In a portal from where?

Do you have a table of Companies?

[Garu]

I have the following tables:

1. Contacts (Event_ID, Contact_ID, Name, Company)

2. Guest (Event_ID, Event_Name)

Table 1 & 2 are related by Event_ID field.

On a Guest layout, I'd like to display a summary base on company name (in a portal and in browse mode) as illustrated on my first post.

[comment]

I am puzzled why do you call a table "Guest" when it is obviously a table of Events.

Anyway, the simple solution is to show a summary report using a layout of Contacts. Sort the records by EventID (or show only the records of the currently viewed event), then by company. Use a layout with a sub-summary part by company, and no body part. Place a summary field defined as Count of [Contact_ID] in the sub-summary part.

To do the same thing in a portal is more difficult, esp. if you don't have a table of Companies - see:

http://fmforums.com/...-portal/#157908

[Garu]

Thanks and sorry for the confusion.