Filter Header Records
I have to produce an invoice for our customers. In the header of the report is the room number of our hotel they were staying in. These are repeat customers (they check in and out periodically). I need to report the room number for the time period they were staying (this month, John Smith stayed in Room 108, but last month he stayed in Room 215. Depending on the invoice I produce, I need to filter his room stay by the table that tracks rooms and customers in them on a given day). How can I filter the table used to produce a field in the header? This table is not used in the Data section of the report, so I can't filter the Data section. Thanks for your help.