DATA REGIONS IN SSRS | REPORT ITEMS IN SSRS

Data Regions:
A data region is a layout element that displays data from datasets.
1.       Table
2.       Matrix
3.       Chart
4.       List
5.       Gauge
Table:
                A table is a data region that presents data row by row. Table columns are static: you determine the number of columns when you design your report. Table rows are dynamic: they expand downwards to accommodate the data. Table can be display detailed data as well as aggregate data.
                Grouping
                   ||
                Only on Row – filed wise
Matrix:
                A matrix is also known as a crosstab. A matrix data region contains both dynamic columns and rows: they expand to accommodate the data. A matrix can have dynamic columns and rows and static columns and rows. Columns or rows can contain other columns or rows, and can be used to group data.        Grouping
                   ||
                On row – filed wise
                &
                Column – field wise
Chart:
Chart is used to present the data in the graphical manner.
*to work chart we have
                Data fields-measures
                Categories & series-Dimensional attributes
*Chart can display only aggregate data.
*Grouping can be applied on
·         Categories
·         Category – filed wise
·         Field – wise
No of groupings decided based on “Chart types”
·         Line chart
·         Build chart
·         Column chart
·         Pie chart
List:
 A list data region repeats with each group or row in the report dataset.
·         List region does not have any built -in – layout.
·         It’s free from layout.
·         List can display detailed data and aggregated data with the help of other report items.
·         List can support only one grouping that is on entire list.
·         A report item placed in the list can be repeated from each row in the dataset/each group in the dataset.
Guage : The Gauge data region is a one-dimensional data region that displays a single value.
Gauges to perform many tasks in a report:
  • Display key performance indicators (KPIs) in a single radial or linear gauge.
  • Place a gauge inside a table or matrix to illustrate values inside each cell.


Two gauge types: radial and linear. The radial gauge is typically used when you want to express the data as a velocity. The linear gauge is used to express the data as a temperature or scale value.

Click the below video to learn more about  DATA REGIONS IN SSRS | REPORT ITEMS IN SSRS

About Author: author 4 + years of Information Technology experience in understanding and analyzing the software and hardware engineering requirements, onsite and offshore management of product development. Expert work on design and development for windows,web,mobile Expert knowledge of C#,ADO.NET, ASP.Net MVC, ENTITY FRAMEWORK, LINQ,COLLECTIONS, JAVASCRIPT,AngularJs 1.0,Angular2, Jquery,Jquery-Ajax, SQL SERVER, XAML,Windows phone 8.1 Good knowledge of WCF-Restful services,WCF, WEB API-Services ,Web- Services,MIcrosoft-Azure,JUICE UI,HTML,CSS,AJAX Read More...

Join him on Google+ | Facebook | Linkedin

No comments