Report Designer: Difference between revisions
Jump to navigation
Jump to search
| (42 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
The nuBuilder Forte Report Designer will open up in a new browser window. | |||
It is a graphical user interface, with drag and drop features, for designing a [[Reports|Report]]. | |||
==New Object== | ==New Object== | ||
This will add a default Object into the Detail Section of the Report. | This will add a default Object into the Detail Section of the Report. | ||
| Line 31: | Line 37: | ||
*Object Type | *Object Type | ||
**Field - Displays a value that comes from the reports [[Reports#Table|Table]]. | **Field - Displays a value that comes from the reports [[Reports#Table|Table]]. | ||
**Label - Text | **Label - Displays Text - these can use [[Hash Cookies]]. | ||
**Image - Displays a PNG Image | **Image - Displays a PNG Image. | ||
*Left | *Left | ||
*Top | *Top | ||
*Height | *Height | ||
*Width | *Width | ||
*Background Color | *Background Color | ||
*Border Color | *Border Color | ||
*Border Width | *Border Width | ||
*Field Name/Title/Source | *Field Name/Title/Source - ''(Field/Label/Image)'' | ||
**Field Name - | **Field Name - A [[Objects#nuScroll|Scrollable]] list that displays a list of values that comes from the report's [[Reports#Table|Table]]. | ||
**Title - | **Title - Text that can include [[Hash Cookies]]. | ||
**Source - | **Source - A [[Objects#nuScroll|Scrollable]] list that displays a list of values that comes from.. | ||
***Field - A Fieldname in the [[Reports#Table|Table]]. | |||
***Image - A list of nuBuilder Forte [[Files|File]]. | |||
***Label - A List with only 1 choice (that can be over written with an actual Label) which is used to keep the Label to the exact size as its Height Property - KEEP EXACT HEIGHT. | |||
*Font Color | *Font Color | ||
| Line 53: | Line 60: | ||
*Format | *Format | ||
*Text Align | *Text Align | ||
*Minimum Rows - In a growable Field Object. | |||
*Minimum Rows | *Maximum Rows - In a growable Field Object. | ||
*Maximum Rows | *Z Index - Objects with larger numbers will appear on top. | ||
*Z Index | |||
==Group Properties== | ==Group Properties== | ||
This will bring up a dialog box that will allow us to do 2 things. | |||
#Sort the records into a certain order before printing. - Sorting on up to 8 [[Objects#nuScroll|Scrollable]] fields. | |||
#Format each sections of the Report. - The properties for each Section are.. | |||
#*Section Height - In pixels. | |||
#*Section Color - HTML. | |||
#*Section Page Break - Start a new page when completed. | |||
#**Yes. | |||
#**No. | |||
==Report Properties== | ==Report Properties== | ||
This will bring up a dialog box with 2 options. | This will bring up a dialog box with 2 options. | ||
| Line 65: | Line 80: | ||
==Copy Changes== | ==Copy Changes== | ||
This will copy the design back to the '''Build Report''' Form and close the Report Designer. | This will copy the design back to the '''Build Report''' Form and close the [[Report Designer]]. | ||
These changes will '''NOT''' be saved until the current '''Build Report''' record is saved! | |||
==Functions== | |||
There are 2 functions that can be used within Group and Report Headers and Footers. | |||
#sum() - eg. sum(inv_total) | |||
#average() - eg. average(inv_total, units) | |||
<div style='background-color:#D8E4FF;padding:10px'> | |||
For these functions to work there must be at least 1 Report Group. | |||
</div> | |||
Latest revision as of 07:02, 11 July 2018
The nuBuilder Forte Report Designer will open up in a new browser window.
It is a graphical user interface, with drag and drop features, for designing a Report.
New Object
This will add a default Object into the Detail Section of the Report.
Clone Object
Doing this will clone any highlighted Objects.
Cloning an Object often saves more time than just adding an Object.
Select Objects
There are 3 ways to select one or more Objects.
- Clicking on an Object. Holding the Ctrl Key down will allow you to add another Object to those already selected.
- Drawing a rectangle around them with your mouse.
- Clicking Select Objects on the Menu.
Adjust Objects
This will bring up a dialog box with options that can adjust all selected Objects..
- Align To Left
- Align To Right
- Align To Top
- Align To Bottom
- Space Vertically
- Space Horizontally
- Thinnest
- Widest
- Tallest
- Shortest
Object Properties
- ID
- Object Type
- Field - Displays a value that comes from the reports Table.
- Label - Displays Text - these can use Hash Cookies.
- Image - Displays a PNG Image.
- Left
- Top
- Height
- Width
- Background Color
- Border Color
- Border Width
- Field Name/Title/Source - (Field/Label/Image)
- Field Name - A Scrollable list that displays a list of values that comes from the report's Table.
- Title - Text that can include Hash Cookies.
- Source - A Scrollable list that displays a list of values that comes from..
- Font Color
- Font Family
- Font Size
- Font Weight
- Format
- Text Align
- Minimum Rows - In a growable Field Object.
- Maximum Rows - In a growable Field Object.
- Z Index - Objects with larger numbers will appear on top.
Group Properties
This will bring up a dialog box that will allow us to do 2 things.
- Sort the records into a certain order before printing. - Sorting on up to 8 Scrollable fields.
- Format each sections of the Report. - The properties for each Section are..
- Section Height - In pixels.
- Section Color - HTML.
- Section Page Break - Start a new page when completed.
- Yes.
- No.
Report Properties
This will bring up a dialog box with 2 options.
- Paper
- Orientation
Copy Changes
This will copy the design back to the Build Report Form and close the Report Designer.
These changes will NOT be saved until the current Build Report record is saved!
Functions
There are 2 functions that can be used within Group and Report Headers and Footers.
- sum() - eg. sum(inv_total)
- average() - eg. average(inv_total, units)
For these functions to work there must be at least 1 Report Group.