Report Generator

Report generator is a reporting tool that provides to take reports that are drafted by the users using queries.
The user takes the reports with the queries that are drafted for listing and determine the filtering and sorting options for the listing too. The prepared report can be added to Access Tree.
"Report Generator" option is located in the Main Records menu of the Decision Support for Management.

In report generator window, in order to add a new report use "New" option that is located in the F9/right mouse button menu.

The following related information is recorded in the report generator window:
Name: The name of the report is entered.
Type: Used to determine the type of the report. Type field contains List and Detailed List options. When Detailed List is selected, the relation between two tables can be defined.
Status: Used to specify the status of the report design.
Heading: The heading of the report.
Get Heading Info From Filter: Used to determine the report heading by using filters. In that case, when a heading is not specified in filter lines, the data will be listed without a report heading.
Print Heading To All Pages: Used to print the report heading to all pages of the report.
User Can Change Sorting and Grouping: Used to change the existing sorting and grouping type of the report.
Line on Access Tree: Used to determine the location of the report on access tree.

The queries drafted for cursor, view, etc. are entered by "The Query That Runs Before Reporting" window.

In Report Query window, the query that will be used for listing must be entered. In this window, not to have a problem in input / output transactions between companies, the table names should be entered in parenthesis before firm and period info is entered.
If required, the user can reach the query editor by using "SQL" icon in lower/left corner.

The column headings of the report can be entered manually in Report Fields window or default headings can be loaded by using right mouse button menu.
The existing columns of the report fields window and their functions are as follows:
Report Field Name: The column name that ill be listed in the report.
Show In Reports Field: Used to determine whether or not the related fields will be listed in data fields in report design.
Show in Default Design: Used to determine whether a field to be listed in data field will be shown in default design or not.
Show in Totals: Used to calculate the related field's total.
Field Width (mm): The width info for the related report field.
Display Type: The displaying type of the fields. The fields can be listed in Numeric, Text, and Date formats. In the event of making "Pict List" selection for the numeric fields, the "List That Belongs to Application" and "Special List" fields will be activated.
List That Belongs to Application: In the event of selecting "Pict List" the info turned back from database can be selected as default from the list that belongs to application.
Special List: The lists that are not taken place in list that belongs to application, can be prepared in special lists by user.


The filters to be used in report are prepared in Filters window.
In final stage, by using "Design" option the default design can be displayed which is prepared for the data that will be listed by query. After recording the design, clicking "Final" option the report design will have been completed.