1.

Explain the different types of data regions in the context of SQL Server Reporting Services (SSRS).

Answer»

Following are the different types of data regions in SQL Server Reporting Services (SSRS) :-

  • Table: A table is a data region that displays data in a row-by-row format. The NUMBER of columns in a table is fixed; you decide how many columns you want when you build your report. Table rows are dynamic, meaning they expand downwards to fit the data. Tables can be divided into groups, which organise data based on selected fields or expressions.
  • Matrix: A crosstab is another name for a matrix. In a matrix data region, both dynamic rows and columns can be present. Dynamic and static columns and rows are both possible in a matrix. Columns and rows can be used to group data and can contain other columns and rows.
  • List: A list is a type of data region that displays data in a freeform format. You can use text boxes, photos, and other data areas to create a form by arranging report items in a list.
  • Chart: A chart is a visual REPRESENTATION of data. BAR, pie, and line charts are examples of charts, although there are much more available.
  • Gauge: A gauge shows data in the form of a range with an indicator pointing to a specific value within that range. Key performance indicators (KPIs) and other metrics are DISPLAYED using gauges. Linear and circular gauges are examples of gauges.
  • Map: You can use a map to present data against a geographic backdrop. Spatial data from a SQL Server query, or Microsoft Bing map tiles can all be used as map data. Sets of coordinates define polygons that represent shapes or areas, lines that represent routes or journeys, and points that are represented by markers in spatial data. You can correlate aggregate data with map items to change their colour and size automatically. For instance, you can change the marker type for a store depending on the volume of sales or the colour for a road depending on the speed limit.


Discussion

No Comment Found