Reports: Difference between revisions
Jump to navigation
Jump to search
Line 22: | Line 22: | ||
A field that can be used to help organise Reports. | A field that can be used to help organise Reports. | ||
===Table=== | ===Table=== | ||
A Table can be created in 2 different ways. | |||
#A SQL statement created with the [[SQL Builder]]. | |||
A | #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. | |||
===Launch From=== | |||
A Form will allow.. | A Form will allow.. | ||
*The user to define the information to be stored in the table (to be used by the report). | *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]]. | *Run the Report from an [[Action Button]] at the top of the [[Forms|Form]]. | ||
=== | ===Design Report=== | ||
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..
- 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.
- 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.
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 Form.