5 Replies Latest reply on Jul 11, 2011 5:49 AM by MatthewMackay

    Reporting Records that Don't Contain Records In the Body's Table

    MatthewMackay

      Title

      Reporting Records that Don't Contain Records In the Body's Table

      Post

      I'm having a slight issue with my reports.

      I am still working on a property inventory solution.

      My report is based on the 'Room Inventory' table.

      This has a leading summary part based on a field within the 'Room Inventory' table.

      Above that is another leading summary part based on the 'Rooms' table.

      There is also a trailing part that shows photos for that paticular room, based on the 'Photos' table.

      The problem I'm having is that within some reports, the user doesn't need to create any records within the 'Room Inventory' table but the report still needs to show that room with it's photos. If there's no records within that room though, the room doesn't show at all.

      Some rooms will have 'Room Inventory' Records and some won't, is there any way of making the report show all rooms regardless of if they have records in the 'Room Inventory' table?

      Thanks

      Screen_shot_2011-07-11_at_13.43.48.png