Creating a PDF Report Application

View video

New Application

With the growing evolution of the Grid/Report application’s features for generating reports, the old PDF Report application was removed from the interface. However, it is still possible to use it.

To enable this functionality, the Scriptcase administrator must access the Options > Settings menu and open the System Settings page.

At the bottom of the page, after the foreign key configuration section, you can enable the old menu application to display it as an option when creating new applications.

Once enabled, the application will appear on the new application creation screen, as shown in the image below.

Application Data

Connection

This field lists all connections in the project and defines the connection that will be used by the application.

Select the connection to list the database tables.

Connection with Data Dictionary

When the selected connection has a Data Dictionary linked to it, the dictionary name will be displayed below the Connection field.

This information indicates that the connection has a configured dictionary, which can be used to fill in the field labels with lang in the generated applications.

By clicking the dictionary name, a screen will be displayed where you can link new tables to the Data Dictionary. Use this option if the table selected to create the application has not yet been configured in the dictionary.

For more details, access the Data Dictionary documentation.

Name

Defines the name of the application that will be created. This field is required and must contain between 1 and 64 characters.

Alphanumeric characters, period (.), hyphen (-), and underscore (_) are allowed. Spaces and other special characters are not allowed.

Table

Defines the table that will be used as the application’s data source.

After selecting the table, the available fields will be listed in the Fields field, allowing you to define which fields will be part of the application.

Fields

Defines the fields that will be part of the applications.

Localization

Defines the default language of the application that will be created. By default, Scriptcase selects the Inherit project default language option, making the application automatically use the language defined as default in the project properties.

If necessary, you can select a specific language for the application. In this case, the application will use the selected language, regardless of the default language defined in the project.

After creating the application, the application language can be changed in Application > Settings. If the Inherit project default language option is selected, the language used will be defined by the project’s default language, which can be changed in Project > Properties.

Edit language charset

You can also change the charset used by the language in the application being created. To change the charset, click the edit button displayed next to the language selection field.

When clicking the button, the option to change the charset of the selected language will be displayed.

Note: This change will be applied only to the application being created. The charset defined for the languages in the project settings will not be changed.

SELECT Command

Displays the SELECT command generated after selecting the tables and fields. This field also allows inserting a previously created SQL statement, as long as it uses tables that exist in the database selected in the connection.

SQL Builder

Opens the SQL Builder in a new browser tab.

This resource allows you to build the SQL command in an assisted way by selecting tables, fields, conditions, sorting, and relationships to generate a custom SELECT.

After building the command, it can be incorporated into the SELECT Command field of the Grid.

Recognize foreign keys and create JOINs automatically

Automatically generates the application’s SELECT command using JOINs, based on the foreign keys existing in the selected table.

This resource is available only when using one table to create the Grid. If the selected table does not have foreign keys configured in the database, the JOINs will not be created automatically.

Relationship

When selecting two or more tables, the “Relationship” tab will be displayed. In this tab, you can view the relationships created between the selected tables.

The relationship will be created and validated automatically, based on the table foreign key configuration.

• OK (Green lines) - The relationship is correct according to the table configuration.
• Error (Red line) - The relationship is incorrect according to the table configuration.
• Saved by user (Yellow lines) - Saved by the user.

This relationship screen is built based on the tables selected in the tables field. If the JOIN is created directly in the SQL field, the tab will not be displayed.

Edit Fields

This screen displays the fields from the selected tables and allows you to make adjustments before creating the application, such as changing the data type, display name, and other settings.

• Fields - Lists the fields from the table used to create the application.

• Label - Defines the text displayed for the field in the generated applications. When the table is associated with a data dictionary, Scriptcase uses the language variables associated with the fields and displays the translation icon, allowing you to change the text of the lang used in the label.

• Data type - Defines the field data type, such as text, number, date, or other formats used by the application.

• Search - Defines whether the field will be available in the application Search.