Example of the Completed Receipt Report, formatted for a POS printer

Advanced Report Design, part 2:

Finishing the Receipt: The Receipt Subreport represents the "many" side of this relationship. This Subreport will show many movies.

 

Plan: The Subreport will be a Tabular Report formatted as a Table.

 

What Are the Steps? Design a new Query to be the Record Source for the Subreport. Create a Receipt Subreport and format the layout with the Table Tools. Add the Subreport to the Receipt Report and confirm the Master and Child Links.

 

What Are the Issues? The Controls and Headers have to be edited before the Report can be resized for the narrow 2" Point of Sale (POS) printer.