Revision as of 22:52, 2 April 2021

Back to Documentation

Fast Report

A Fast Report is just a term that refers to a Report built using Fast Report.

The Fast Report Builder allows you to quickly add columns, titles and totals to a new Report.

Create Fast Report

To create a Fast Report you will need to do 4 things...

Choose a Table Data
Select from its available Fields
Make any changes to Title, Field Name, Width and Sum.
Click the Fast Form Report button

Sample Reports

With Subtotals

Report Builder / Designer

nuBuilder Forte has a built in drag and drop Report Builder.

This is used for designing the layout of a Report created with a temporary table via the #TABLE_ID# Hash Variable in the Reports Button under the Setup Tab.

Grouping

This Report Builder can cater for up to 8 grouped fields each with a Section Header and Section Footer.

Along with a Detail Section and Report and Page Headers and Footers.

These sections can contain any number of 3 different Object Types..

Objects

Field

An Object who's value will change because it displays the value of a field from a temporary table created with the Hash Variable #TABLE_ID#. Other than a fieldname from a table, a field Object in a nuBuilder Report can also accept 1 of 2 functions:

SUM(a)
AVERAGE(a,b)

Both are for use in Header Sections or Footer Sections SUM(a) will add all of the rows of a together for that section. AVERAGE(a,b) will essentially evaluate as SUM(a) / SUM(b) for that section.

SUM and AVERAGE require at least 1 report group (other than Report and Page groups) to give a result

Conditional formatting is available in nuBuilder for changing the background and font color of a Field Object.

By prefixing a value with 10 characters eg. '#B#66FF99|' will change the background color to #66FF99 (red).

By prefixing a value with 10 characters eg. '#F#FF0000|' will change the font color to #FF0000 (light green).

By prefixing a value with 20 characters eg. '#B#66FF99|#F#FF0000|' will change both font and background colors.

A PHP example setting the colours depending on the values is:

<source lang="php"> $s = ' CREATE TABLE #TABLE_ID# SELECT * FROM customer INNER JOIN invoice ON customer_id = inv_customer_id ';

nuRunQuery($s); $s = "ALTER TABLE #TABLE_ID# CHANGE inv_number inv_number VARCHAR(100) NOT NULL"; nuRunQuery($s);

$s = "Update #TABLE_ID# set inv_number = concat('#B#66FF99|',inv_number) WHERE inv_number < 60"; nuRunQuery($s);

$s = "Update #TABLE_ID# set inv_number = concat('#F#FF0000|',inv_number) WHERE inv_posted = 1"; nuRunQuery($s); </source>

This fill create a Report formatted something like this..

File:Capture.PNG

Label

A hard-coded value that does not change with the exception of when it contains a Hash Variable like Page, Pages Year etc.

The Available Hash Variable to the Label Object are..

page
pages
description
code
year
month
day
hour
minute
second

Image

An Object that displays the path to an image file.

This can be from 1 of 3 places. (And is checked for in this order.)

Contained in a field within the the temporary table.
The Code of an image stored within nuBuilder's Image table.
A hard-code URL accessible by the browser.

Report Menu

New Object

Creates a default Field Object in the Detail Section, that can be dragged with-in the current Section or into other Sections with the mouse.

Clone Object

Clones all highlighted Objects and moves these Cloned Objects 2 pixels to the right and highlights them while un-highlighting the original Objects.

Select Objects

Displays a list of all Objects in this Report, ordered by the Sections they belong to. Highlighting any will in turn highlight the Objects themselves.

Adjust Objects

Adjust all highlighted Objects as described by the button title.

Object Properties

F=Available to Field
L=Available to Label
I=Available to Image

Object Name

(F,L,I)

Object Type

(F,L,I)

Top

(F,L,I)

Pixels

Left

(F,L,I)

Pixels

Height

(F,L,I)

Pixels

Width

(F,L,I)

Pixels

Background Color

(F,L)

hex or name eg #6495ED or cornflowerblue.

Border Width

(F,L,I)

Pixels