Multi,table,report,How,Include computer Multi table report: How to Include Sub-Reports
----------------------------------------------------------Permission is granted for the below article to forward,reprint, distribute, use for ezine, newsletter, website,offer as free bonus or part of a product for sale as longas no changes a Gone are those times when the companies and the organisations didn't need a hi-tech system to handle them. Owing to the considerable increase in the business sector and thus, an enormous increase in the complexity of the organisational struc
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.
Multi,table,report,How,Include