SQL Server Reporting Services

Here we will learn how to design an SSRS report that will export each region to a separate worksheet in Excel.

The following report contains four Tablix regions. Each one is a table with a single row group representing a calendar year. The Dataset contains a SELECT statements that aggregates sales amount by year and country:

Here we will learn how to design an SSRS report that repeats the column headers of a Table on every page.

The following report contains four Tablix regions. Each one is a table with a single row group representing a calendar year. The Dataset contains a SELECT statements that aggregates sales amount by year and country: