Power View and Reporting Services 2012 Book

Several projects kept me very busy over the past year. I will talk more about a few of these in subsequent postings now that some are publicly disclosed in the meantime. In this posting, I am very happy to announce the availability of “Professional Reporting Services 2012”. After the successful Report Design Recipes book focusing…

0

Turn-Based Gaming Against AI in RS Reports (aka BI Power Hour 2009)

At the traditional annual “BI Power Hour” sessions several teams contributing to the Microsoft Business Intelligence platform show off their technology in a fun way.  It is about demonstrating, in perhaps unusual ways, of how business intelligence and various tools of the BI stack can be useful. In past years, Reporting Services made a number…

2

Reporting From Analysis Services Data

The SQL Server Customer Advisory Team published a new technical case study on Analysis and Reporting Services, Design and Implementation.  You can read the summary here, as well as download the full 55 page document. Among other topics, the case study explains how to use so-called server aggregates in reports calculated by Analysis Services, report…

0

RDL 2010, RPL, RGDI

SQL Server Reporting Services 2008 R2 introduces the RDL 2010 format with enhancements such as Maps, shared dataset references, page breaks , as well as RDL expression language additions such as Lookup, and aggregates of aggregates. You can now download the RDL 2010 specification as XPS file.  You can still download specifications for previous RDL…

0

Report Design: Naming Excel Worksheets

One of the frequent feature requests for Reporting Services was to add the ability to define data-dependent names for worksheets when exporting to Excel. Reporting Services 2008 R2 adds this capability through a more general feature to name pages.  In Excel export, report page names determine the name of worksheets. The report item with the…

0

Report Builder Portal

Are you looking for how to get started with Report Builder 3.0? videos and tutorials of how to create report parts? news about and downloads for Report Builder? pointers about Report Builder report design capabilities, such as sparklines and data bars, gauges, indicators, maps, creating drillthrough reports, subreports, page layout and rendering? If yes, you…

0

Report Builder 3.0 RTM

The Feature Pack for Microsoft SQL Server 2008 R2 was released for download earlier this week, and includes PowerPivot for Excel 2010, as well as Report Builder 3.0! The stand-alone download package for Report Builder 3.0 is available here: http://www.microsoft.com/downloads/details.aspx?FamilyID=d3173a87-7c0d-40cc-a408-3d1a43ae4e33 You can read about several of the new features and scenarios enabled with Report Builder…

0

Globals!RenderFormat aka Renderer Dependent Report Layout

One of the design principles of the Reporting Services platform is that you author a report once, and it then renders to all interactive and export formats with as much fidelity as possible (and enabled by the underlying export format). You don’t need to worry how certain report items and style settings translate to HTML…

0

Book Reviews: Recipes for Designing Expert Reports, Introducing SQL Server 2008 R2

Teo Lachev is a well-known Reporting Services MVP, speaker at conferences, and authored several Reporting Services and Analysis Services books in the past.  Teo recently wrote a book review of “Reporting Services Recipes – for Designing Expert Reports” on this blog.  Enjoy!  In his review Teo says another title for this book might have been…

0

Report Design: Shrinking Hidden Static Table Columns

Reporting Services 2008 introduced the ability to dynamically hide table columns and shrink the width of the table (and the report body) at the same time automatically. That said, you also have the ability to just hide the contents, but not the actual table column and preserve the space. I see this question come up…

0