SQL Server Reporting Services R2 – New Features

Leave a comment (0) Go to comments

Using Business Intelligence for SQL Server 2008R2 you can create reports based on many data source types.  Report services not only uses Microsoft but also Oracle, ODBC, XML, SAP, Hyperion Essbase and Teradata data connections.

There are a variety of report types available to you:

Table

displays data in rows and columns that can be grouped to show aggregated data.

Matrix

pivot table

List

free form report like a word document

Chart

graphical representation of data

Subreport

Add an existing report to another report

The following are new items that have been added to the SQL 2008R2 Report Toolbox.

SQL Server Reporting Services R2   New Features SQL Server Reporting Services R2 New items SQL Server Reporting Services R2 New Features SQL Server Reporting Services sql server report Sparkline Sql Server report SharePoint integration sql server report map sql server report Indicator SQL Server Report Gauge SQL Server Report DataBar SQL Server 2008 R2 Reporting Services

Gauge

Data region that shows Key Performance Indicators

Map

Spatial data that is embedded in a report


DataBar

Used with text data in tables and matrices

Sparkline

Used with text data in tables and matrices

Indicator

Gauge that shows the state of a single data value

The look has changed. Gone is the Data tab, it is replaced by the Report Data panel.  This panel allows you to add new Data Sources, Datasets,  Images, Parameters and use Built-in Fields after you create a report.
SQL Server Reporting Services R2   New Features SQL Server Reporting Services R2 New items SQL Server Reporting Services R2 New Features SQL Server Reporting Services sql server report Sparkline Sql Server report SharePoint integration sql server report map sql server report Indicator SQL Server Report Gauge SQL Server Report DataBar SQL Server 2008 R2 Reporting Services

The availability to add page numbers, Total Pages, etc. is now located in the Report Data panel.
SQL Server Reporting Services R2   New Features SQL Server Reporting Services R2 New items SQL Server Reporting Services R2 New Features SQL Server Reporting Services sql server report Sparkline Sql Server report SharePoint integration sql server report map sql server report Indicator SQL Server Report Gauge SQL Server Report DataBar SQL Server 2008 R2 Reporting Services

Row and Column Groups are now located in a separate section located at the bottom of the Design window.
SQL Server Reporting Services R2   New Features SQL Server Reporting Services R2 New items SQL Server Reporting Services R2 New Features SQL Server Reporting Services sql server report Sparkline Sql Server report SharePoint integration sql server report map sql server report Indicator SQL Server Report Gauge SQL Server Report DataBar SQL Server 2008 R2 Reporting Services

SQL Server 2008 R2 has a new Report Builder 3.0.  End users can create charts, use gages and create maps.  The following in an example from Microsoft example of using maps what shows the use of maps.
SQL Server Reporting Services R2   New Features SQL Server Reporting Services R2 New items SQL Server Reporting Services R2 New Features SQL Server Reporting Services sql server report Sparkline Sql Server report SharePoint integration sql server report map sql server report Indicator SQL Server Report Gauge SQL Server Report DataBar SQL Server 2008 R2 Reporting Services

Another feature is the ability to use SharePoint services as the database to store the report metadata.  In future posts, I will discuss and demonstrate how to create different report types and use SharePoint.

EOF - SQL Server Reporting Services R2 – New Features, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.