Temporary tables, available within designers such as Report Designer, Label Designer, and JSON/XML Designer, offer exceptional customization capabilities for tailoring reports to specific print requirements or needs. This functionality allows users to define an unlimited number of custom tables to sort, define, and form information precisely as required.
The primary application of temporary tables is to categorize and group items on any report, such as a sales order, work order, stock adjustment, or purchase order, in ways that go beyond standard invoice layouts. For instance, on a sales order containing items like windows, services, and spare parts, you might want to create separate lists for each category instead of a single consolidated list.
The application process involves several key steps:
1. Report Setup: Begin by creating a new report designer, for example, for a sales order. You’ll define the document header and basic structure, including elements like the customer or other foundational data, using a wizard.
2. Defining Temporary Tables: Users can create an unlimited number of temporary tables. For a sales order, you might define tables named “windows,” “services,” and “spare parts,” each with specific properties like scope, description, quantities, and type (e.g., “amount” for summing values).
3. Populating with Logic (Blockly Scripts): To populate these custom tables, Blockly scripts are used to integrate logic and automation. These scripts iterate through item rows and apply rules based on item type or category. For example, if an item’s category is “Internal Services,” it’s added to the “services” temporary table. If it’s “Internal Materials” or “Spare Parts,” it goes into the “spare parts” table. These definitions are case-sensitive.
4. Structuring Report Display: Once populated, you define how these temporary tables will appear in the report, including setting up necessary columns for each table (e.g., “windows” table, “services” table, “spare parts” table).
5. Runtime Application: When printing a sales order (or any other document), the user can select and define the order item types using these custom tables. This allows for a perfectly tailored report that sorts, defines, and forms tables according to specific needs, offering significant freedom in report design once the underlying Blockley script logic is understood.
Recent Comments