get count of portal records

[scottvaughan]

I need a simply way to get a count of the portal records in my layout. The portal is part of a reporting module. It is linked to my main job tracking db. I have various portals that show me jobs printed on a certain day, shipped on a certain day and whether or not they are late based on a comparison of due date and ship date. I would like to have a simple counter at the bottom of my layout showing me how many of each I have in a given day.

[Keith LaMarre]

you can script it - or keep a field in the main file - count(related_records::serial_Number)

[Fei]

Create a summary field and choose COUNT of any portal fields.

[scottvaughan]

I did the summary and it does not seem to work. Do I need to have it in the body? I have it in the footer now. It does not seem to recognize the portal records. The portal has a relationship that is to another file. Could that be the problem?

[bruceR]

The summary field suggestion was wrong. Use the count function.

count(relationship::keyField)