I suspect the answer is, without some heavy lifting, "you can't get there from here". But, here goes anyway....
I have Members
I have Awards
It is a 1 to many relationship with Awards
There are many Awards (Attendance, Best Harley) etc.... SOME of them are Milestone Awards (25 YR, 30 Yr etc)
I have a report that has a filtered portal (filtered on: g25Yr, g30Yr... etc...)
Of course the portal is set to collapse when Print or Preview. That works.
But, when in simple Browse mode there are useless, blank rows. From what I read in various forums, there really isn't anyway to have the portal blank rows collapse except when in PREVIEW. I need 10 rows because it is 'possible' that someone might receive all 10 Milestone Awards. But, most of the time I only need a few rows in the portal.... Oh, the 'tragedy' of it all!
I suspect that unless I want to use virtual lists, I am stuck with this 'as is'