Title
need help for Arrangement record, Vertical sort VS horizon sort
Post
Hi eveyone,
I m using FMP pro9 with win vista
I have a database with 5 records in Table 1:
1)
|ID| Name| Price|
|1 | A | 1 |
|2 | C | 2 |
|1 | B | 2 |
|2 | A | 1 |
|1 | C | 3 |
If I make a report layout with sort by ID and by Price I will have report shown in Table 2:
2)
|ID| Name| Price|
|1 | A | 1 |
| | B | 2 |
| | C | 3 |
|2 | A | 1 |
| | C | 2 |
Now I want to make another report show the same information in Table 1 and 2, but in different way as in Table 3:
3)
-------------------------------------------
|ID | Name1 | Name2 | Name3 |
---------------------------------------------------|
|1 | A | B | C |
| |Price1=1 | Price2=2| Price3=3|
|--------------------------------------------------|
|2 | A | C | |
| |Price1=1 | Price2=2| |
|--------------------------------------------------|
Can anyone tell me if possible that I can have the report/layout for 3) and how?
Thank so much.
It takes some work and you lose some reporting flexibility (What happens if you have more names than will fit in one horizontal row?) but it can be done.
The simplest approach is to use what's referred to in Filemaker circles as a "horizontal portal".
If you haven't already, define a report where you have one record for each ID value.
Define a relationship as: IDtable::ID = YourTable::ID
Now you can place a conventional portal to YourTable on a Layout based on IDTable.
To make it "horizontal" to get your row, you place this portal in position as column 1--specifying that it show Initial Row: 1, Number of rows: 1.
Put a copy of this portal in column 2 and specify Initial row 2, Number of rows 2.
Repeat for each column, specifying sequential initial rows.