Reports

nuBuilder Forte can create PDF Reports from the data stored in its database.

To do this we need 3 things.

1. Data in a table.
2. A nuBuilder Form where the user can define what information will be in this table - generally a Launch Form.
3. A Report designer.

These Reports will allow the user to do things like..

• Share information with others.
• Help make business decisions.
• Create invoices.
• Print graphs.

Creating a Report

Code

A unique Code for this Report

Description

The description of this Report

Group

A field that can be used to help organise Reports.

Table

A Table can be created in 2 different ways.

1. A SQL statement created with the SQL Builder.
2. A PHP Procedure that can create the table and manipulate it before it is used by a Report.

The Table Lookup contains both of these types.

All of the SQL records have 'SQL' as their code.

Launch From

A Launch Form will allow..

• The user to define the information to be stored in the table (to be used by the report).
• Run the Report from an Action Button at the top of the Form.