AnsweredAssumed Answered

FM 15 ADV Reporting too much data

Question asked by synergy46 on Jul 12, 2016
Latest reply on Jul 23, 2016 by Mike_Mitchell

I have 2 tables:  Members and DES

Members is 1 to many with DES

DES has a portal on the Members layout

This works.

 

The problem:

When I produce a sub-summary report I get ALL the DES records for each members. 

I want to get just the first (top row) in the portal in the report.

 

I suspect that I need a different DES TO ?????

Below is the portal for Rudolph Graham:

DESPortal.png

Below is the DES Sub-Summary Report..  Notice the presentation of each portal row in the

sub-summary report.

 

DESReport.png

Question:  "How do I show just Graham's 'top' portal record (Reinstated) in the report?

 

Thanks

Outcomes