Information Technology Blog

Report Types:
The structure of the layout must be known to design a report on paper. There are three types of reports, which resemble the Form types I, II and III. In designing a report, these layout types are built with specific layout types in the Maintain Report Layouts (ttadv3131s000) session. Here are some examples of the three types of reports.

Type 1 report
The Type 1 report is a standard report with the data being listed in a horizontal format. Note that for each item (making up a single record), several lines are required to display the data.

Type 2 report

In a type 2 report, the data in each row belongs to a different record, and the columns represent fields of each record.

Type 3 report

This type of report displays records related to a common key (view). In figure , gardening tools and measuring tools are two examples of a common key with related records listed beneath the key.

Introduction
A report is a description or a summary of activities in an organization. A report is often a periodical statement on the state of various activities, for example, Customer Balances, Sales Statistics, and so on.

Data flow from tables to paper

Figure shows how data flows from a database table through a session or query through a report to the printer, which then presents the results on paper. A data flow through UNIX is not depicted in this figure.

To use an existing report, there has to be a session to retrieve the data from the BAAN tables. There will be selection criteria from which to choose on a form (screen) of type 4. After the printing process begins, additional information must be supplied, such as the report to be selected, printer (or device) to be used, and so on.

If a query is used to retrieve the data for a report, a report name must be entered for the query. After the query begins, the process is similar to the process using a session, in that additional information must be entered.

There are other ways to view data besides printing reports. For example, a display session can be used to retrieve the required data.

Report Management

A form makes a selection of what data is going to be printed on the report. The report obtains the information from the object, then formats the data and sends it to the output device. The formatting is done in correlation to what was created in the report script/editor.

At the report level you can define the paper type, sort, priority and ascending/descending order options.

Print Session Coding

Figure shows the break down of the coding of a print session. For more information on the coding of BAAN sessions see the “Customization and Development – General Data” Module Description.

Maintaining Report

The purpose of the Maintain Reports (ttadv3130m000) session is to maintain reports. A report is used to output data within the database. A report consists of input data, layouts, and may have a report script. Each layout consists of report fields, special fields, labels and layout texts.

Menu: BAAN IV Tools / Application Development / Reports

Session: Maintain Reports (ttadv3130m000)

Report input fields

The table fields or program script variables may be specified here. If the input field is a table field, then the depth and domain are taken from the table definition and cannot be changed. If the input field is a program script variable, the variables must be declared as extern in the script from which the report is called.

1 Click on the Input Fields button in the lower left corner of the screen

2 Go to EDIT, select Insert

3 Enter the data as shown in the following figure:

4 Another option:

5 Go to SPECIAL, and select Copy Fields from DD. You would see the Input screen in

figure, which lists all tables available to dmoes

6 Click OK, the following session would appear:

7 Select the fields you DO NOT want to appear on this session (hold the CTRL key and click to make multiple selections). The display should look like the following screen: