On Cross-Tab Crosstab Cross-tabulation) is a special report element in SAP Crystal Reports that cross-tabulates two dimensions and displays the aggregated values in a matrix — typically customers or articles in rows, months or quarters in columns, and sums, quantities, or profits in the cells. It is therefore the classic basis for pivot analyses directly within a report.
Context
A cross-tab is inserted on Insert → Cross-Tab; As a cross-tab expert, row, column, and sum fields are defined. In addition to simple sums, minimum, maximum, average, count, and percentages are also possible; multiple key figures can be stacked on top of each other. A typical Business One example: gross revenue per customer (row) over twelve months (column) with an annual total column on the right. The column order can be flexibly controlled – for example, for deviating business year July to June — by dynamically naming columns in the underlying query like Value_Month_01 to Value_December generated and linked in the cross-tab. In combination with drill-down markersREFER-Links) can allow double-clicks on cells to jump directly to an SAP B1 form or a detailed posting. Formatting (conditional backgrounds, omitting zero cells, highlighting outliers) is controlled via the Formula Workshop.
Demarcation
A cross-tab is not an interactive pivot table like in Excel: rows, columns, and measures are fixed at design time; users cannot regroup them in a live report—for that, you need Pervasive Analytics or a real BI tool. It is also not identical to a normal Group SummaryThis sums along one dimension, a cross-tab crosses two. For pure detailers, the classic details band remains the right choice; cross-tabs shine where density and comparability count.
ReAct and RLEF: How Artificial Intelligence Learns from Real Mistakes — and What Automated Bank Reconciliation in SAP Business One Has to Do with It
SAP B1 10.0 FP2608: Service Layer AI as a transactional layer
Process Reward Models: Why a correct result does not yet prove a correct method
Test-Time Compute Scaling: Why a Smaller AI Model Can End Up Winning — and What Supplier Comparison in SAP Business One Has to Do With It
RLHF and reward models: AI hype or what the approval process in SAP Business One has to do with it
