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

From	lansingoogle <ls@jillo.com>
Newsgroups	comp.databases.filemaker
Subject	Re: How to build an array with data from a single table?
Date	2011-12-09 16:29 -0800
Organization	http://groups.google.com
Message-ID	<2625888d-3194-4a51-87cc-3414e67cbdd8@v6g2000yqv.googlegroups.com> (permalink)
References	<b96595f2-8f8d-41d9-bf1a-27b4c42f652c@y6g2000yqe.googlegroups.com> <1kby4hk.1c3bt0ygskjjkN%clkaufmann@gmx.ch>

Show all headers | View raw

On Dec 8, 1:32 am, clkaufm...@gmx.ch (Christoph Kaufmann) wrote:
> lansingoogle <l...@jillo.com> wrote:
> > 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.).
>
> Create global fields for the year and the month. Build a reation to a
> second table occurence where the city matches, and the global fields for
> year and month on the left side with the data fields for year and month
> with the right side.
>
> You can now create a calc field to get the month's total for the city
> with the sum function.
> --http://clk.ch

Thank you Christopher.  At the moment I'm caught up in the strange
world of Virtual Tables that Lynn alerted me to.  Your approach is
probably closer to what I would naturally gravitate towards - though
I'm not certain I'm smart enough to fill in the unspoken assumptions.
But I'll give it a whirl...

THANKS!!!

Back to comp.databases.filemaker | Previous | Next — Previous in thread | 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