Fixed and Variable ReportsEstimated 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.
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.
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.
Using the report seen in the Financial Report - Walkthrough, this example will illustrate how to use a ReportVariable() in a financial statement use case.
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.