Tool Bar Option
Description
New
Define a new report.
Open
Open an existing report file.
Save
Save the report definition. See Saving the Report Definition.
Report Wizard
Launches the Report Wizard for creating a new report.
Options
Launches Report Options.
Preview
Preview the report output. See Testing the Report.
Send the report to the alternate output destination selected from the drop-down list: Clipboard, Custom Output, HTML document, PDF document, Printer, Tab delimited file, Viewer.
Cut
See Editing the Layout.
Copy
See Editing the Layout.
Paste
See Editing the Layout.
Find
Find the specified text value in the layout. Find will search data items, formulas and fixed text within the cells.
Find Next
Find the next instance of the specified text value in the layout.
Insert Row
Insert a line below the current line.
Delete Row
Delete the current line.
Insert Column
Insert a column to the right of the current column.
If the Inherit attributes from column on left when inserting a column designer option has been turned On, then when a column is inserted, the cell attributes (i.e. font, colors, alignment, word-wrap and borders) from the previous column (on the left) are inherited on a cell-by-cell basis. If column 1 is inserted or the option is not selected, then the column cells will be assigned default attributes.
Note:
If the cell to the left is a joined cell (see
Join), the inherited attributes would be those of the cell if it were not joined and therefore may not match the attributes displayed when joined.
The Inherit attributes from column on left when inserting a column option is at the bottom of the main Report Designer panel and in the Designer Options window, which is accessed through the Options menu.
(The Inherit attributes from column on left when inserting a column option was added in PxPlus 2023.)
Delete Column
Delete the current column.
Join
Merge the highlighted cells. If the value in a cell spills into the next column, you should join the cells. For printed output, this may not always be necessary as the value will print outside of the cell area, but HTML output requires that such cells be joined to maintain proper column spacing. A common use of joined cells is to centre titles across several columns. Cells may be joined across columns and rows, but the rows must be in the same section.
In iNomads, where only one cell can be highlighted, the Join Cells window shown below is presented to specify the total number of columns and/or total number of rows, including the anchor cell, to be joined.
(The Join Cells window was added in PxPlus 2018.)
(The Join tool bar option was added in PxPlus 2021.)
Font
Set the Font and font attributes (i.e. style, point size, orientation).
Text
Select the Text Colour.
Background
Select the Background Colour.
Text Alignment
When an item is added to the layout, a text item will be Top Left justified and a numeric item will be Top Right justified.
Text alignment for selected items can be adjusted by clicking one of the horizontal alignment buttons (Left, Center, Right) and/or one of the vertical alignment buttons (Top, Middle, Bottom).
(Compound text alignment menu options were added in PxPlus 2019.)
(Horizontal/vertical alignment toolbar buttons were added in PxPlus 2020.)
Border width
Adjust the border width to Thin, Medium or Wide. The width must be set prior to adding the border.
Borders
Set preference for displaying Borders. Available selections are Full grid; Edges Only, Inside only, Left Edge; Right Edge, Top Edge, Bottom Edge, No Borders. All borders are black.
Set Line Condition
Launches the Define Filters dialogue for adding a condition to a line. See Conditional Lines.
Set Cell Condition
Launches the Define Filters dialogue for specifying the conditions under which an alternate cell definition will be used. See Alternate Cell Condition.
Switch Cell
Switch between two cell definitions if an alternate cell definition has been created. See Switch Cell Definition.