Jump to content
Sign in to follow this  
kmtenor

Sub-Summary in Browse Mode

Recommended Posts

Hello.

I have a list of data that I want to display to users in Browse Mode, and I need to find a way to visually separate the sections of it when the date field changes. The best way I can think to describe it is that, when I build the layout with a sub-summary field that displays when sorted by date and contains a horizontal line, I get EXACTLY what I want - in Preview Mode. But I need my users to be able to interact with the data.

I have found several references to making lines appear or other layout elements change based on either the number of records that have been displayed, or on some other criteria in the current record. All of the examples I've found use a calculation field to determine when and how to change its contents (most often, the calculation field returns a container result, and the element being turned on and off is held in a global). This would work, if I could just find some way to make a field in the current record aware of the value of a comparison field in the previous record.

I'm hoping someone else has already solved this issue. I'm afraid this one has me stumped.

Thanks.

-Kevin

Share this post


Link to post
Share on other sites

Interesting thought, Robert, but I'm afraid the consumers of this application are looking for a way to be able to tell - at a glance - how many items are on the list for each day. Scrolling through portals probably won't work in my particular case.

Thanks, anyway!

Share this post


Link to post
Share on other sites

In FM8/8.5, you can use GetNthRecord() to look into the records above or below the current one in the found set. It shouldn't be too hard to use that to look for a change in your date field and determine the right graphic as a result.

Share this post


Link to post
Share on other sites

Thank you, Ender! That was the perfect solution. The code to get the date field from the next record worked out like this:

GetNthRecord(date_to_invoice; Get(RecordNumber)+1)

Thanks again!

-Kevin

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.