Create modular reports with report parts SQL Server


show more Report parts let you create modular reports that incorporate multiple elements. By creating report parts from data stored in your SQL Server you can configure data individually and then combine them later for a more in-depth report. Follow along as this online video guides you through the process of creating modular reports with report parts. show less
please wait ...

Creating modular reports with report parts

So far, in all the reports I have created I have just been using one element per report, so one table, or one matrix, one chart or one map. It is of course much more likely that we will want to create reports that combine multiple elements at the same time, and you can just do that, just add multiple elements to the same report and configure them the way you want them. But its often very useful, particularly when learning Reporting Services, that you don't want to try and create this massive report all at once; instead, it's more useful to configure the pieces individually and combine them later.

And one way to do this is using report parts. It's a simply idea: take an element of report like a matrix or a table and just save it by itself, without the rest of the report, without titles or footers, just the table, just the chart, just the matrix, and save it to the server. And if that report part is a data region it can be saved together with its data source and dataset embedde...

Creating modular reports with report parts
Video duration: 4m 36s 3h 44m Advanced

Viewers:

Report parts let you create modular reports that incorporate multiple elements. By creating report parts from data stored in your SQL Server you can configure data individually and then combine them later for a more in-depth report. Follow along as this online video guides you through the process of creating modular reports with report parts.

Subjects:
Developer IT
Software:
SQL Server
Author:
please wait ...