|  Organizer Advantage HowTo/Help  |  Designer HowTo/Help  | 

Advantage Help > Reports > Print Report Window

Reports / Print Report Window

Report options are grouped on tab pages. In order to create a report set your options.

Main
The main page displays information about the report:

• Data From (source type: table, view, statistics), table name, report name, report description.
• Report options let you define report title and the report scope: print from the current record (the selected record on the grid), print from first (default setting), print 1 record, print all displayed records, print from page, print to page.
• The double-sided printing option allows you to print directly from the Print window on both sides of each paper.
• You can save report options in the report template (for example, to print a report with the content of the selected record, set the following option: From Current and 1 Record).

Data Fields
On the Data Fields page select the data fields that you want to include in your report (highlight a field on the left-side list and click on the Green Arrow button. If you want to include next field in the same line or column then press on the Plus button. If you selected Fields In Columns as Report Layout you can specify the widths of individual fields (highlight a field on the right-side list and enter the width value into the Width edit box).

Use Up/Down arrow buttons to change the order of fields on your report.

You can define simple grouping: select the Sort By field, click Group Report by "Sort By" field. "Group By" Report instead of printing all records together. In a report you can have separate reports for each group of records. In order to use this function the primary sort field has to be the same as the group by field.

Total Numerical Fields: your reports can automatically display totals for the selected numerical fields: Total Numerical Field.

Options
You can decide which report layout options you want to use: print field names, include grid lines, and decide on the report format that you would like to use (see below: Report Layout). The default layout is Fields In Columns. After you set your report layout options click Quick Preview to preview changes. The quick preview report displays only several records on one page. To check the whole report click Preview Report.

Page
You can set page margins, page size, and page orientation.

Select the font type/size/color for the report on the Fonts page (click on Change Font button).

Title
Define the report title and additional options on the Report Title page.

After the report has been created you may want to test it by clicking on the Preview button. If you are not satisfied with the report adjust the report options and Preview it again.

If you think you may want to use this report in the future save the report as a Report Template by clicking on the Save button. Later you can reuse the saved report by clicking on the Load button.

Saved reports are also accessed from the Main toolbar.

Organizer Advantage, Simple Database Solutions

Organizer Advantage, Business Database Solutions

Organizer Advantage Free Service

Organizer Advantage Support

Database Blog:
Advantages of Database Software over Spreadsheet Applications
Firebird SQL Tutor
Custom Wine Inventory Database

Free Database Templates