When you create a report, you must associate it with a table or view; this table or view provides the majority of the information you want to include in the report. If you want information from other tables, you can use expressions to look up this information.
One way to include information from more than one table in a report is to build a query to specify the data you need, and then save the conditions as a view. You can then use the view as the driving view for the report.
You can create the following types of reports:
Quick Report (Report Wizard) - Use this option to create a report from a table or view you select using the Report Wizard. The Report Wizard automatically places column objects that correspond to columns you choose. A quick report doesn't contain any other features; however, you can add features to this report and change the layout.
When you create a quick report, you also select how the field objects will be displayed; in rows across the page, or in columns down the page.
Custom Report - Use this option to create a blank report, and then you can add the features you like.
We will be designing and building our reports in the Report Designer.
