AnsweredAssumed Answered

need help for Arrangement record, Vertical sort VS horizon sort

Question asked by Shaunnx on Apr 5, 2010
Latest reply on Apr 7, 2010 by 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.

Outcomes