Reports: Difference between revisions

Revision as of 12:56, 6 July 2017

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

To do this we need 3 things.

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

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

A unique Code for this Report

The description of this Report

A field that can be used to help organise Reports.

A Table can be created in 2 different ways.

A SQL statement created with the SQL Builder.
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.

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

@@ Line 22: / Line 22: @@
 A field that can be used to help organise Reports.
 ===Table===
-The data that will be displayed
+A Table can be created in 2 different ways.
-===Launch From===
+#A SQL statement created with the [[SQL Builder]].
-A nuBuilder Form.
+#A PHP [[Procedures|Procedure]] that can create the table and manipulate it before it is used by a Report.
-===Design Report===
+The '''Table''' Lookup contains both of these types.
-===Build a Form===
+All of the SQL records have 'SQL' as their code.
+===Launch From===
 A 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 [[Forms|Form]].
-===Build a Table===
+===Design Report===
-A Table can be created in 2 different ways.
-#A SQL statement created with the [[SQL Builder]].
-#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.
-All of the SQL records have 'SQL' as their code.