Multi –table report: How to Include Sub-Reports

Microsoft access report can help you in creating single table-report as well as multi-table report. Multi-table reports can be very useful as these reports help the users to look at the individual records or collection of data that are grouped by a logical category.

For instance, if the database, in which you are working, holds information regarding sporting goods stores, and you need to make the sales report of each of the store, then it is always better to make multi-table report that depicts the sales volumes of each store. You can also add a sub-report that can contain the information regarding the individual product categories that are sold within each store.

If you want to make sub-reports in the multi-table report of Access 2007, then firstly you need to select the table or query which will be served as the basis of your report. Then go to Create > Report Wizard to initialize the Report Wizard tool.
The query or table that you have selected can be seen in the Tables/Queries list. If you want to choose the different source, then select the new source from the same list and then select the field which you need to include in your report. Finally use the > button in order to add them in the report wizard.

One can add more fields and tables in the report by selecting the new query or table from the Tables/Queries list. Choose the appropriate fields and include them in your report. You can repeat this step as many times as you want to get all the fields that you want in the report. Once you have added all the appropriate fields and tables as you require, then click on the ‘next’ button.
Next what you have to do is to choose the table that will serve as the base of your main report. For example, in the case of sporting goods store, the main report will include the sales data of each store. Once again click ‘next’ button when you have chosen the main report source.

Click on the field that illustrates the sub-groupings you want to include in your report. Taking the store example, the sub-groupings can be soccer products, cycling products and running products. When all the sub-groups have been added, then click on the ‘next’.
Last few steps include the sorting process of the report, selecting the layout and orientation and finally the title of your report.

Article Tags: Main Report

Source: Free Articles from ArticlesFactory.com

ABOUT THE AUTHOR