Once created, PDF Reports can be run from a number of places within nuBuilder.
Reports can also be run directly from the Run Report Button under the Setup Tab.
This will open a new Window and display the Report
The Fields required for creating one of these records are..
The code is a unique label for the report which is used to help find the appropriate record.
Used to describe and help find the appropriate record.
Placing similar types of reports in the same group can be used to help find the appropriate record.
Create Temp Table
TABLE_ID is the hash variable that holds the name of the temp table containing the information for this report..
SQL SELECT Used To Create #TABLE_ID#
SELECT * FROM product INNER JOIN zzzsys_file ON zzzsys_file_id = IFNULL(pro_image,'nuimage') ORDER BY pro_code
PHP Used To Create #TABLE_ID#
$s = " CREATE TABLE #TABLE_ID# SELECT * FROM product INNER JOIN zzzsys_file ON zzzsys_file_id = IFNULL(pro_image,'nuimage') ORDER BY pro_code"; nuRunQuery($s);
A Form that allows the User to add criteria..
More about how to use the Report Builder can be found here.
The corresponding Report Builder page is: Report Builder Example
Fig 2, Report Builder Example
The PHP code above and the Report Builder Example shown in Fig 2, together will form this PDF report. Example Report