4.8 Convert the Results to a Report
To create reports for your queries you can use Crystal Reports. Crystal Reports is a powerful What-You-See-Is-What-You-Get (WYSIWYG) reporting tool allowing you to design sophisticated reports quickly and easily using point-and-click commands. Crystal Reports is used for the report example shown in this section.
Crystal Reports has its own user guide and tutorials.
Once you have created a report, you can save it for future use.
To create or attach a Report to your results, from the Results menu on the menu bar, select:
- Report Designer, to create a new report or amend an existing report.
- Report, to display the results using an existing report format.
Remember that you should save the query's results as a DBF/MDB file before requesting a report.
Tip
If you have a report which contains a large amount of data, you may wish to save the report together with the data. To do this, tick the Save data with Report option in Crystal Report's File menu. So that you do not overwrite the data (using the Refresh option) the next time you run the report, you should copy this report file to another name. To include new data next time you run the report, either deselect (i.e. untick) the Save data with Report option, or select the Refresh option when you run the report.
Further Information