12 Replies Latest reply on Mar 23, 2009 10:49 AM by philmodjunk

    Need some help with a report - grouping relational fields

    Skeyelab

      Title

      Need some help with a report - grouping relational fields

      Post

      I am stumped a bit. 

      I have 3 tables, Estate, Room and Item

       

      Each table has "id" fields.  Room has a field called "parent_estate" and Item has a field called "parent_room"

       

      the relationships are Estate -< Room -< Item,  as eash estate has multiple rooms, and each room has items.

       

      I currently have a layout that allows me to page by estates, and see my items.  I also have a Portal that lists the Estates rooms, and allows a user to create a room.

       

      I want to put a button on this layout that will generate a report, for the current estate only.  I want to report to list estate details in the header, along with our logo, etc.  I want the report to list the items in the estate grouped by rooms.

       

      I cant seem to get the report to work the way i want.  I got it working kind of how i wanted, but its listing all of my estates. 

       

      Can anyone help me with this?  I am more than happy to provide more info if necessary.

       

      Eric