Level: Advanced, Version: FM 16 or later, Virtual List

Virtual List Simplified

Demo file: virtual-list-simplified.zip Note 1: The example in today’s article/demo is intentionally very basic. Note 2: The demo is self-populating to keep the data current, so the values you see in the screen shots will not exactly match those you encounter in the demo. Recently I had the pleasure of discussing virtual list with Paul… Continue reading Virtual List Simplified

JSON, Level: Intermediate, Version: FM 16 or later, Virtual List

Faux Subsummaries via JSON + Virtual List

Today we’re going to take another look at a challenge we discussed last time (in Conditional Summary Report Header)… namely how to cajole FileMaker into displaying a subsummary, or a reasonable facsimile thereof, at the top of a report page when items in the group begin on an earlier page. Demo file: Faux Subsummaries via… Continue reading Faux Subsummaries via JSON + Virtual List

JSON, Level: Advanced, Version: FM 16 or later, Virtual List

Virtual List Reporting with JSON Arrays

Acknowledgment: As always a huge thank you to Bruce Robertson, for inventing virtual list, and for many other contributions to the FM community over the years. Introduction As a follow up to my recent “Virtual List on Steroids” presentations at DIG-FM and dotFMP, today I want to take a fresh look at using JSON arrays… Continue reading Virtual List Reporting with JSON Arrays

Level: Intermediate, Virtual List

Virtual List on Steroids

[Note 1: as always a huge thank you to Bruce Robertson, for inventing virtual list, and for many other contributions to the FM community over the years.] [Note 2: the following assumes the reader is familiar with basic concepts presented in Virtual List Reporting, part 1.] This is a follow up article to document new… Continue reading Virtual List on Steroids

JSON, Level: Intermediate, Version: FM 16 or later

JSON Array + Virtual List

10 Sep 2017: Dave Graham has made a couple significant improvements to the original demo file that accompanied this article. I recommend reading his comments at the end of this article, and using the techniques featured in his version of the demo file — dg-json-array-plus-virtual-list.zip. Over the last few postings we’ve been looking at using […]

ExecuteSQL, JSON, Level: Intermediate, Version: FM 16 or later

Virtual List Reporting + JSON

Update 29 June 2018: see Virtual List Reporting with JSON Arrays for updated thoughts on this topic. Today we’re going to look at an alternative approach to the multi-window VLR technique we examined last month in Virtual List Reporting part 3, utilizing and extending techniques introduced in last month’s JSON + Virtual List. To avoid… Continue reading Virtual List Reporting + JSON

JSON, Level: Intermediate

JSON + Virtual List, part 2

31 July 2017: As per my exchange with Beverly Voth in the comments section, the date encoding technique used here is strictly intended for situations where FileMaker will both produce AND consume the JSON. Demo file: json-plus-virtual-list-part-2.zip This is a short follow-up to part 1, to demonstrate an alternative idea re: JSON date encoding. As… Continue reading JSON + Virtual List, part 2

JSON, Level: Intermediate, Version: FM 16 or later

JSON + Virtual List

31 July 2017: As per my exchange with Beverly Voth in the comments section of part 2, the date encoding technique used here is strictly intended for situations where FileMaker will both produce AND consume the JSON. 29 July 2017: demo has been updated to require a minimum version of FileMaker 16.02 as per my… Continue reading JSON + Virtual List

Level: Advanced, Version: FM 13 or later, Virtual List

Virtual List Reporting, part 3

Last year I posted a couple articles on the topic of virtual list reporting (part 1 and part 2), a.k.a. VLR. Today we’re going to look at some additional things you can do with VLR, and to avoid a lot of repetition, this article will assume the reader is familiar with the material covered in… Continue reading Virtual List Reporting, part 3