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

Maybe you could have a list view with a portal in each record to display the data for that particular date ?

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

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