Reports: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 13: | Line 13: | ||
=Building a Report= | |||
==Code== | |||
A unique Code for this Report | A unique Code for this Report | ||
==Description== | |||
The description of this Report | The description of this Report | ||
==Group== | |||
A field that can be used to help organise Reports. | A field that can be used to help organise Reports. | ||
==Table== | |||
A Table can be created in 2 different ways. | A Table can be created in 2 different ways. | ||
#A SQL statement created with the [[SQL Builder]] that will create the table. | #A SQL statement created with the [[SQL Builder]] that will create the table. | ||
| Line 30: | Line 30: | ||
All of the SQL records have 'SQL' as their code. | All of the SQL records have 'SQL' as their code. | ||
==Launch From== | |||
A Launch Form will allow.. | A Launch Form will allow.. | ||
*The user to define the information to be stored in the table that will be used by the report. | *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 [[Forms|Form]]. | *Run the Report from an [[Action Button]] at the top of the [[Forms|Form]]. | ||
==Report Designer== | |||
nuBuilder Forte has its own [[Report Designer]]. | nuBuilder Forte has its own [[Report Designer]]. | ||
=Running A Report= | |||
There are 2 ways to launch a Report. | There are 2 ways to launch a Report. | ||
#Click the '''Run Report''' Button on the Setup Tab of the Home Form. | #Click the '''Run Report''' Button on the Setup Tab of the Home Form. | ||
#Create a Button with a custom click event to run <span title="Javascript" style="background-color:#f8dc3d;padding:2px">nuRunReport("INV");</span> (INV being the Report code ) | #Create a Button with a custom click event to run <span title="Javascript" style="background-color:#f8dc3d;padding:2px">nuRunReport("INV");</span> (INV being the Report code ) | ||
Revision as of 00:44, 8 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.
Building 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 that will create the table.
- 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 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.
- Click the Run Report Button on the Setup Tab of the Home Form.
- Create a Button with a custom click event to run nuRunReport("INV"); (INV being the Report code )