The Original FileMaker Community
Business Templates - Demo Apps - Video Tutorials -Samples - Help - 46000 Member Forum

The Leading Filemaker Developer Tools

Superfast Reporting with PSOS and Virtual Lists w/ Anders Monsen

Get real time updates directly on you device, subscribe now.

Faster Reports with PSOS and Virtual Lists

Anders Monsen’s DevCon 2017 presentation is loaded with great tips about PSOS and Virtual Lists, something your clients need from time to time. He doesn’t stop there, however, as he combines the use of ExecuteSQL to really speed up reporting.

If you haven’t built virtual lists before, watch this video and learn how to build powerful reports using PSOS and Virtual Lists.  If you have, watch this video to learn how to optimize what you already know.

If you haven’t heard of Virtual Lists, it’s a technique for easily grabbing data from multiple sources, saving it into global variables, and parsing the information into an unrelated table.  It’s a powerful technique that free a developer from some of the constraints of normal FileMaker reporting.

Here a partial list of the subjects covered in the video:

  • How to grab easily parsed data using ExecuteSQL (hint: don’t use the default delimiter)
  • How to build and test scripts in PSOS
  • Tips from the audience on things to test for when running PSOS
  • How to store the data in a global variable and parse it into the virtual table on the fly
  • How to add headers to the virtual table report
  • Formatting options to make the report look better

There are four free FileMaker downloadable files available, as well.


This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Read More