I received this in my inbox and thought I'd pass it along. Love to visit with anyone that wants to attend! (Dwayne)
Jason Young will be speaking on two very exciting topics; Pivot Tables
& Cross Tab Reports and how to easily integrate QuickBooks and FileMaker.
Pivot Tables and Cross Tab Reports:
Pivot tables or Cross Tab Reports are reporting tools used to display the
joint distribution of two or more fields in a table. Typically this is done
in a matrix, called a Contingency table, where one set of field values will
be represented by rows, and another will be represented by columns. Most
people are familiar with these reports from their experience with Excel
Pivot Tables, so we'll start by looking at the Excel functionality. We'll
then look at a traditional FileMaker approach of replicating this by using
multiple relationships. We'll conclude the presentation by looking at a new approach using some of the newer features available in FileMaker like variables, arrays, and the List Function, which open up some new ideas for gathering and displaying data.
We will also review a powerful new tool called 123Sync™ that synchronizes QuickBooks and FileMaker® Pro. In as little as an hour developers and FileMaker novices can integrate a database, stopping the redundant re-entry of data from FileMaker files into QuickBooks Accounting.
The meeting will be held on Wednesday, May 28, 2008 from 6:30 PM until 8:30 PM. The meeting will be at the Washington Mutual Center, 1301 2nd Avenue, 42nd Floor, Seattle, WA 98101. Be sure to visit http://www.fmpug.com to register for the meeting (that way you can get past the security desk.) For the monthly Seattle Chapter FMPug raffle give-away, Phil Smith of FileMaker is giving away a copy of FileMaker® Pro 9. Laura Bowyer of SolutionMakers will provide snacks & coffee for the evening. Washington Mutual has once again donated the beautiful meeting space, the White Oak Room on the 42nd floor at the Washington Mutual Center in Seattle, Washington.