AnsweredAssumed Answered

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

Question asked by MatthewMackay on May 25, 2011
Latest reply on Jul 11, 2011 by 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

Outcomes