Reports: Difference between revisions

From nuBuilderForte
Jump to navigation Jump to search
Line 26: Line 26:
#A PHP [[Procedures|Procedure]] that can create the table and manipulate it before it is used by a Report.
#A PHP [[Procedures|Procedure]] that can create the table and manipulate it before it is used by a Report.


The '''Table''' Lookup contains both of these types.
This Lookup contains both of these types.


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

Revision as of 12:59, 6 July 2017

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 that will create the table.
  2. A PHP Procedure that can create the table and manipulate it before it is used by a Report.

This 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.

Design Report