Reports

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

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. Use of the Report Designer.

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

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

Building a Report

There are 3 things needed to create a Report.

1. An Edit or Launch Form that contains values used by the Report eg From Date and To Date.
2. A Table containing data to be used by the Report.
3. A Report designer to create the way this data is displayed.

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 3 different ways.

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

This Lookup contains all these types.

• All of the tables have 'nuTable' as their code.
• All of the SQL records have 'nuSQL' as their code.

Launch From

A Launch Form will allow..

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

Report Designer

nuBuilder Forte has its own Report Designer.

Running A Report

There are 2 ways to launch a Report.

1. Click the Run Report Button on the Setup Tab of the Home Form.
2. Create a Button with a custom click event using nuRunReport().