QuickDevGuide

Home › SSRS Report Development

Tablix: Grouping, Totals & Drilldown — SSRS Report Development

Tablix is the engine behind tables, matrices and lists. Data region Shape Typical use Table fixed columns, row groups detail listings with subtotals Matrix row and column groups pivots: products × months List free-form repeated panel cards, letters, invoices Grouping Add row groups (Region → Country) and column groups (Year → Month). Totals: right-click the group → Add Total (before/after). Interactive drilldown Set a child group's Visibility to Hidden and Toggle by the parent group's textbox — users expand Region to see Countries. Combine with document map labels and interactive sort on headers. Pagination Use page breaks between instances of a group (one region per page) and repeat header rows on each page (Advanced Mode → RepeatOnNewPage = True).

Key Takeaways