Organizer Advantage is powerful yet easy to use database manager for Windows.
Advantage Designer lets you modify our solutions or easily create new databases.
Take control of your data with our simple or buinsess database software solutions.


 |  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).
organizer advantage, report window, main section

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.

organizer advantage, report window, data fields selection

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.

organizer advantage, report window, grouping

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

organizer advantage, report window, calculate totals

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.

organizer advantage, report window, options

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

organizer advantage, report window, page margins, size, orientation
Fonts

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

organizer advantage, report window, font size, font type

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

organizer advantage, report window, report title

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, report window, predefined reports, saved reports

Copyright © 2024 · All Rights Reserved · PrimaSoft PC