Portal overflow display

[dr9000]

I have a invoice layout that only has room for 10 portal rows. I'd like the last portal row to show something like "X addition items" if there are more than 10 items in the portal. If someone could point me to some examples of how this might be done, it would be very helpful.

 

Thanks.

 

 

[comment]

Why don't you simply set up the portal to show a scroll bar?

[Fitch]

I agree with comment, but I have had customers request this.

 

One solution is, create a calc field and put it below the portal (not on the last row):

 

Let( rows = Count(related::id) - 10 ;

Case( rows > 0 ; rows & " additional items" ) )

 

The downside of doing something like this is that you can't take advantage of object auto-resizing.

 

Welcome to the forums.

[dr9000]

Why don't you simply set up the portal to show a scroll bar?

I do have a scroll bar in the main layout but this is for a printable view that gets handed out to techs. 

 

I agree with comment, but I have had customers request this.

 

One solution is, create a calc field and put it below the portal (not on the last row):

 

Let( rows = Count(related::id) - 10 ;

Case( rows > 0 ; rows & " additional items" ) )

 

The downside of doing something like this is that you can't take advantage of object auto-resizing.

 

Welcome to the forums.

Thanks, I'll give that a try.

[comment]

this is for a printable view that gets handed out to techs

 

Then why not print from the child table and print all the required records? Surely that would be more useful than "there are 6 more items that could be important but we're not going to tell you anything about them"?