The Report Wizard in Access 2007 can help you create a single-table or multi-table report. Multi-table reports help you look at individual records or data collections grouped by a logical category. For example, if your database holds information about sporting goods stores, and you want to create sales reports for each store, you could create a multi-table report that shows you the sales volumes for the individual stores. A sub-report might contain information about individual product categories sold within each store.
To create a multi-table report with sub-reports in Access 2007, first you'll need to select the table or query that will serve as the basis of your report. Select Create > Report Wizard to start the Report Wizard tool.
The table or query you selected will appear in the Tables/Queries list. To choose a different source, select a new source from the Tables/Queries list, then select each field you want to include in the report, and use the > button to add them to the Report Wizard.
You can add more tables and fields to the report by selecting a new table or query from the Tables/Queries list and choosing the appropriate fields for inclusion. Repeat this as many times as necessary to get all of the fields you want in your report. When you have added all of the appropriate tables and fields, click Next.
Choose the table that will serve as the basis for the main report. In the case of the sporting goods store example, the main report will contain sales data for each store. Other tables you may have included in your report may show types of sporting goods for sale in each store. When you have chosen your main report source, click Next.
Click the field that shows the sub-grouping you want to use in your report. In the store example, sub-groupings might include soccer products, running products and cycling products. When you have added all of your sub-groups, click Next.
Choose the sort order for your report. The sort order will determine how your report information appears when all relevant records have been sorted appropriately. Click Next.
Add any summary calculations. These calculations will allow you to create a summary total for numerical fields related to each sub-group in the report. For example, a summary report might give you total sales in pound, or the total quantity of a particular item in a report. Click Next.
Select the layout and orientation for your report. Select the report style for your report and give your report a title. You may preview your report and make any needed modifications. When you are done, click Finish.
By using the Report Wizard, you can create in-depth multi-table reports and sub-reports in Access 2007.
ไม่มีความคิดเห็น:
แสดงความคิดเห็น