Re: 2D relations

#1

Martin Trautmann <t-usenet (AT) gmx (DOT) net> wrote:

Quote:

I got a list or records

name place
A 11
B 13
C 14
D 21
E 24

All of them do belong to group X,
while there may be other groups Y, Z, ...

I want to show them as

Group X:
(column) 1 2 3 4
(row) 2 D E
(row) 1 A B C

How many columns are there? The crosstab approach in Filemaker's
developer's essentials suggests to create a calc field per column.

With many columns, and a varying amount of columns, you could use a loop
script to build an HTML table and feed it to the web viewer as data URL.
Easy to display, not easy to print.

--
http://clk.ch

#2

Martin Trautmann <t-usenet (AT) gmx (DOT) net> wrote:

Quote:

Group X:
(column) 1 2 3 4
(row) 2 D E
(row) 1 A B C

The example shows 4 columns only. The max. number would be 9 since I do
permit any number from 1:9 x 1:9 (11 to 99, but no zeroes).

I'd create a crosstab report with 9 calc fields like this one for column
7:

If ( <second digit of place number> = 7 ; Name ; "" )
--
http://clk.ch

#3

Martin Trautmann <t-usenet (AT) gmx (DOT) net> wrote:

[Crosstab report]

Quote:

Ok, you would organize it in columns instead of rows,
but how is this supposed to work, how would the layout setup be?

List view and dummy records 1:9 for the row number?

Crosstab report works with list view (or subsummary parts with summary
fields). Columns need to hard coded, so you can write the column headers
directly on the layout.
--
http://clk.ch

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: 2D relations

comp.databases.filemaker comp.databases.filemaker

Re: 2D relations - 03-14-2010 , 02:04 AM

Re: 2D relations - 03-14-2010 , 02:34 AM

Re: 2D relations - 03-14-2010 , 04:31 AM