• View
• Edit
• History
• Print
• Backlinks

Defining simple report

For registration of the report, we can use option Simple reports->Add report or we can press buttom Add report in option Simple reports->List of reports.

Selecting one of these options to display a registration form report:

where you specify:

• group to which the report will be assigned
• data source from which to retrieve data for the report
• enabled formats report output files
• additional options:
  • Numbering of rows - the first column in the report is the line number
  • Final number - the number of records displayed at the end of the report
  • Zebra - alternating rows marked with a different color
• name of report
• description of report - any text describing the defined report
• title of report - the title of the report is placed in the central part of the header (in the field we can use symbols of simple reports)
• headline right - the header part which is placed to the right side (in field we can use symbols of simple reports)
• footer of report - any text located in the lower part of the report (in field we can use symbols of simple reports)
• SQL executed before the report - in this section we define the execution of a stored procedure PL/SQL (in field we can use symbols of simple reports), for example EXECUTE PROCEDURE spl_generate("1?!","2?!")

• Main SQL - main SQL query based on which the report is generated (in field we can use symbols of simple reports)

Defining fields

Adding column

To register column in the report is section Columns of report. To register a column you must fill fields in this section:

• Name of column
• Width of column (how many characters)
• Type of columns selected from list
• Sum - if the field is defined as Integer or Decimal, the choice of the value Yes of this field will force a final summary column

and click icon . Then the column definition will be added to the list at the end. If we have defined several columns and we want to add a column between two already defined, it should be in field No enter the number of columns before that we want to put a new column:

Example:

and after click of icon :

Editing column

If you wish to pre-defined column to edit, we need to click on the icon in the row you want to edit:

Saving changes after you click on the icon :

Deleting column

To delete a previously registered column, use the icons in the row you want to delete:

Defining conditions for data selection

The selection criteria defined in the report row can reduce the scope of selected data. Each condition is available as symbols and can be used in the Main SQL of report.

Selection conditions can be referenced in two ways:

• <number_of_condition>!? – returns the phrase resulting from the combination of the value entered in the field Name of field and the value entered for this condition in the form displayed before the generation of the report, for example state="A"
• <number_of_condition>?! – is returned only the value entered on the form that appears before the report generation, for example "A"

Example:

In the case below:

before the generation of the report displays the form:

and SQL will be as follows:

SELECT login,forename,surname FROM ge_users 
   WHERE login like "%admin%"