Dialética

SSRS, SSRS 2012 takes the integration several steps further. By using SSRS 2012 in SharePoint Integration

Mode, users can deploy, manage, and deliver reports and report objects, like web parts, data sources,

and models, even entire dashboards or portals, all within the SharePoint environment. In addition, the

deployed reports inherit the native features of SharePoint, such as workflow capabilities and the ability

to check in and check out reports, and report change notification. We will demonstrate this tighter

integration with SharePoint in Chapter 12.

Tablix Report Properties

As the name suggests, the Tablix properties first seen in SSRS 2008 combine two existing report controls,

Table and Matrix. This combination gives developers a more flexible tool when creating reports. The

availability of multiple columns and rows blends the static nature of the Table control with the dynamic

nature of the Matrix. Reports can now accommodate multiple parallel rows and column members at

each level, independent of each other but using the same aggregate calculations. In previous editions of

this book, we provided workarounds to combining tables and matrices by embedding one within the

other. In Chapter 4, we will explore the true power of the new Tablix control properties for the List,

Table, and Matrix controls.

Enhanced Charting and Report Item Visualizations

From the beginning, SSRS offered charts and visualizations natively in reports. These charts, while

versatile, were somewhat limited in scope. Much, if not all, of the functionality in the charting aspects of

previous versions of SSRS could be easily duplicated in Microsoft Excel. In fact, the charting was almost

identical. SSRS 2008 provided several charting and graphical data-visualization enhancements vital for

the sound BI reporting solution of which SSRS is a pivotal component. New charting elements such as

range, polar, radar, funnel, and pyramid are available, as well as many new “gauges” delivered with the

acquisition of Dundas reporting controls for SSRS.

SSRS 2008 R2 included several eagerly-awaited report item visualizations to enable the creation of a

more sophisticated dashboard look and feel. One is the Map control that can display data from a

geospatial data result set or an Environmental Systems Research Institute, Inc. (ESRI) shape file. Other

great additions include Data Bars, Sparklines, and Indicators. We will explore several of these new

visualizations as