Skip to main content

Fields and Build Panel

The Fields and Build panel is the primary data-binding interface in the Output Designer. The left portion lists all blueprint sections and their available fields. The right portion (the Build panel) shows the component-specific binding slots — called wells — for the currently selected component. Dragging a field from the section list into a well binds that data dimension to the component.

Report Forge fields and build panel

Panel structure

Section list (left)

All reporting sections exposed by the blueprint are shown in a collapsible tree. Expand a section to see its available fields. Fields are typed: Text (T), Number (N), Date (D), Boolean (B), or Calculated (fx).

Build panel (right)

Shows the wells specific to the selected component type. Wells are labelled by their role (e.g., "Category", "Value", "Series", "Start date"). Some wells are required (marked with an asterisk); others are optional.


Well types per component

ComponentWells
TableColumns (one or many fields), Sort field, Group by field (up to 3)
MatrixRow group (up to 3), Column group (1–2), Value field
Chart (bar/line/area)Category or Date, Value (one or many), Series (optional), Tooltip fields
Pie / DonutCategory, Value, Tooltip fields
ScatterX axis field, Y axis field, Series (optional), Label field
BubbleX axis, Y axis, Size field, Series, Label
KPI Card (single)Metric field, Comparison field (optional), Sparkline period + value
KPI Card (multi)Category field, Value field, Sort field
GanttActivity label, Start, Finish, Baseline start, Baseline finish, Progress, Status
Cash flow curvePeriod, Baseline value, Actual value, Forecast value
Earned valuePeriod, PV, EV, AC, BAC
Resource profilePeriod, Value, Group by (optional), Capacity (optional)
WaterfallLabel, Value, Step type
TreemapCategory, Value, Parent (optional), Color field
FunnelStage label, Value
Decomposition treeRoot metric, Decomposition fields (ordered list)
Box plotCategory, Value, Series (optional)
Scatter-BubbleX, Y, Size (bubble only), Series, Label
MTAMilestone, Period, Forecast date, Baseline date
MapLatitude, Longitude, Label, Color/status, Size
SlicerField (the dimension to filter on)
Subreport(No fields — uses parameter mapping instead)

Aggregation options

For numeric fields dropped into value wells, set the aggregation in the well settings:

AggregationDescription
SumTotal all values. The default for cost, hours, and count fields.
AverageMean value across rows.
CountNumber of rows.
Count distinctNumber of unique values.
MinSmallest value.
MaxLargest value.
FirstFirst value in sort order.
LastLast value in sort order.
Custom expressionEnter a formula referencing other fields (see Calculated fields).

Aggregation is applied per component well, so the same field can be summed in one well and averaged in another.


Calculated field binding

Calculated fields appear in the field list with an fx type badge. They behave identically to regular fields in binding — drag them into wells like any other field. Calculated fields are evaluated per row before aggregation.

To create a new calculated field, click + Calculated field at the bottom of the field list panel. See Parameters and Calculated Fields for full expression syntax.


Field binding workflow

  1. Select a component on the canvas.
  2. In the Build panel, identify which wells are required for the component type.
  3. Expand the relevant blueprint section in the field list.
  4. Drag a field into the required well (or click the well and select a field from the picker).
  5. Set the aggregation function for numeric wells.
  6. Click Preview to see the component render against the active edition's data.
  7. Adjust field selection, aggregation, or sort order as needed.

Common binding patterns

PatternComponentsTypical fields
Detail recordsTable, listMany fields from one section.
Category and valueBar chart, pie, funnel, treemapLabel field + numeric value field.
Time seriesLine chart, cash flow, S-curveDate/period field + value field(s).
Metric and targetKPI card, gauge, progress barMetric field + optional target field.
Schedule visualGantt, resource profile, EVActivity, dates, progress, cost fields.
Cross-tabMatrixRow group + column group + value field.