Take a look at the image below and you should be able to spot an Access subreport embedded into the main report.
See how the order summary information appears to be seamless to the profile information showing no border edges, scroll bars and other unwanted properties too.
Microsoft Access Subreport: The Key Properties When Embedding A Report
The following properties are some of the key elements that trick the user into thinking this was just one rich formatted report but in reality, it’s at least an Access subreport which can also be optionally not linked to the main report too.
- Switch off the border to no border or format as the same background colour.
- Remove all the scrollbars, there’s no reason to display as this is summary and should fit into one view.
- Remove all sections that give away the clue to an Access subreport like the report and page header and footers. You only need to really use the detail section.
- Related data should be linked between the subreport and main report by a common field (relational data values).
Microsoft Access Subreport: The Key Properties When Embedding A Report
The Property Sheet is where all properties can be set and you need to be in the Access subreport design view to gain control of the above properties and more.
Keep saving your work as to save any heartache of losing your hard work.
There are many other properties, techniques and good tips to learn from my eBook on How to Build Access Database Reports – Creating that all professional look!.
Tags: access database report, access subreport, access subreports, microsoft access report, MS Access, reports in access
Notice in my image that the summary value was coloured red and blue based on the value being greater ot leass than £1000. This was applied using the Conditional Formatting tool in Microsoft Access. Want to know how? contact me.