Groups | Search | Server Info | Login | Register

Groups > comp.databases.filemaker > #508

How to build an array with data from a single table?

Show all headers | View raw

I have a client that wants an excel-style report composed of data from
a single table.  In this case, the records contain "city" data and
creation dates, and they want a report that will have cities
populating the 'rows', and records-per-month populating the columns
(columns would be Jan, Feb, March, etc.).  So... San Francisco: 4
records in Jan, 6 records in Feb, 1 record in Mar etc.

My plan was to base the layout on the primary table (with a sub-
summary part sorted by city), but I'm stymied by how to get the
records-per-month data into the vertical columns in any kind of an
elegant manner (without too many subsidiary tables, added fields,
etc.).

I'm sure this is a common challenge, and that there's a 'best-
practice' way of achieving it.  My hope is that some kind expert out
there will see this and enlighten me!!

The client is using FM9, with FM 9 Server (all windows xp).

Many thanks in advance.

Back to comp.databases.filemaker | Previous | Next — Next in thread | Find similar

Thread

How to build an array with data from a single table? lansingoogle <ls@jillo.com> - 2011-12-07 14:59 -0800
  Re: How to build an array with data from a single table? clkaufmann@gmx.ch (Christoph Kaufmann) - 2011-12-08 07:32 +0100
    Re: How to build an array with data from a single table? lansingoogle <ls@jillo.com> - 2011-12-09 16:29 -0800
  Re: How to build an array with data from a single table? lansingoogle <ls@jillo.com> - 2011-12-09 17:29 -0800

csiph-web