Fixed and Variable Reports

Estimated reading time: 1 minute


This section demonstrates additional Report Formulas, ReportFixed() and ReportVariable(). Like ReportRange(), these are used for reporting but allow for special use cases. ReportFixed() provides for a report that is fixed on each row based on a Row Definition that you specify. If the returned record matches the Row Definition, the data is presented, but the report does not expand with new data records. The ReportVariable() function is a combination of ReportFixed() and ReportRange() which allow specific fixed sections to be set up. Within those sections, the data will expand or shrink based on the data result.

Inventory Fixed Report

This page illustrates the process of building a fixed inventory report from scratch using an example seen in the Inventory Walkthrough. By creating this report from scratch, you can better understand how to use the ReportFixed() function.

Inventory Variable Report

Using the report seen in the Inventory Walkthrough, this illustrates how ReportVariable() can provide all the data for each section in the report Inventory By Category with Detail.

Financial Variable Report

Using the report seen in the Financial Report - Walkthrough, this example will illustrate how to use a ReportVariable() in a financial statement use case.

Customer Aging Detail Report

This advanced example uses both the ReportRange() and ReportVariable() functions together to build an auto-expanding report that provides aging detail drilled to in the Customer Aging - Walkthrough example.