Exforsys

Home arrow Reviews arrow SQL Server Reporting Services

Report Builder 2.0 - List

Author: Packt Publishing     Published on: 31st May 2009    |   Last Updated on: 1st Nov 2010

The list data region repeats for each row of data. List element provides a single container for the data which can be used to generate what are called Free Form Reports. In this kind of report there is no rigid structure such as a table for the data. You can also place a list inside another list or even a chart inside a list. You can drag a column from a dataset and drop it into the list. You can work with the list using the properties of the Rectangle it contains as well as its Tablix properties.

Ads

As described earlier, the design interface is very flexible and you can leverage all features provided by the Tablix structure like displaying details and adding groups either independent, or nested. The properties pages described earlier allow you to sort and filter grouped data.

When you drop a List on the design surface you will see just a single cell as shown. You can change its dimensions to suit your needs.

When you click on the List you can access its handles as shown.

When you add a List, there is one column and one row (just one cell). This can be extended in both directions by choosing the appropriate submenu items. These can be displayed by right-clicking on the handles as shown.

Ads

In Chapter 7, you will be creating free form reports using the List data region.



 
This tutorial is part of a SQL Server Reporting Services tutorial series. Read it from the beginning and learn yourself.

SQL Server Reporting Services

 

Comments