Cross-Tab

E-invoicing in Germany: How to implement the obligation with SAP Business One

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.