2 Replies Latest reply on Apr 7, 2010 5:58 PM by Shaunnx

    need help for Arrangement record, Vertical sort VS horizon sort

    Shaunnx

      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.

        • 1. Re: need help for Arrangement record, Vertical sort VS horizon sort
          philmodjunk

          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.

          • 2. Re: need help for Arrangement record, Vertical sort VS horizon sort
            Shaunnx

             

            THank you very much for your reply, I am a newbie with FM , and your guide is really helpful to me.

             

            This drive me crazy, FM is somehow restricted compare with other softwares. I can not take any value of any field in any record and display in wherever I want in a layout.

             

            I will post after solving this problem