List of Products PDF Report

This report lists all products with Number, Name, Model, Make, Responsibility, Manufacturer, Supplier, and Unit price by default, but any available field in products can be added.

Filter and Order

We provide nine filters by default, Number, Name, Model, Make, Responsibility, Supplier: Name, Manufacturer: Name, Item: Name, Item: Item Number. If more filters are needed, select Add more filters.
The order of the products is by default set to Number.

We provide default filters based on the report type and context. If additional filters are necessary, select Add more filters to see a list of additional fields that can be used to filter the content further.

Select the ellipses (three dots) in the order by menu to define the order for the content.

Report Content

We show eight columns with the following column widths: Number (10%), Name (*), Model (10%), Make (10%), Responsibility (10%), Manufacturer (15%), Supplier (15%) and Unit price (10%) which can be adjusted to include any room fields. The asterisk * denotes no width defined and is what is left over, making up 100% after using the columns defined with a width.

Each column can have a different header by overwriting the header once a field has been selected.
Header Groups are used to add a header above that groups field together. If fields have the same value, we will group them.
The width can be defined as a percentage (%), pixel (px), inch (in), millimeter (mm), or point (pt). It is recommended not to mix methods for the best results. We default to a percentage if no unit is provided behind the number.
Aggregation can provide a summary of numerical columns.
An aggregation label can be defined with the aggregation value we calculate.
Text alignment can be modified for each column. We default text to the Left. We default numbers to the Right. Options are Default, Left, Right, or Center.

More options

Report titles are defaulted to match the original name of the built-in report, but they can be overwritten.
Report subtitles can be defined but are empty by default.
The Paper size defaults to A4 but can be modified to A3, Ledger, Letter, and Tabloid.
Page Orientation is defaulted to Landscape but can be modified to Portrait, but keep in mind that column widths may need to be adjusted.
The report output format is defaulted to PDF. In older reports, there are other options (see Format)

See Report Filters and Order, Report Content, and More Options for additional features are generally available across all reports.

Report Output