Robert Bruckner's Reporting Services & Power View Blog

Power View, Tips and Tricks for SQL Server Reporting Services, RDL Report Design, Business Intelligence

Browse by Tags

Tagged Content List
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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 . ...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: Report Design: Reset Page Number on Group

    One of the frequent feature requests for Reporting Services was to add the ability to reset page numbers within the report, e.g. based on a change in the group value. Reporting Services 2008 R2 adds this capability through a more general feature to name pages, and define dynamic page breaks and optionally...
  • Blog Post: Reporting Services Recipes Book Downloads

    The Reporting Services Recipes book contains detailed step-by-step instructions and explanations for each report design recipe. We also know that readers want to learn at their own pace, and sometimes don’t have the time to go step-by-step, but instead want to play with the final report first and then...
  • Blog Post: Reporting Services Recipes Book Released

    This book should be on the shelves any day now and is truly special! It draws from the experience of many Reporting Services industry experts and brings together best practices and report design patterns. I co-authored this book with Paul Turley, and it also includes great contributions from Grant Paisley...
  • Blog Post: Refreshable Reports in Word, PowerPoint, Excel

    Microsoft Office supports several ways of embedding images into Office documents: Insert – statically inserts a copy of an image into the document. Link – creates a virtual connection with that image without actually embedding it in the document. Insert and Link – insert...
  • Blog Post: SQL Server 2008 R2 November CTP – What’s New In Reporting Services?

    The November CTP download is available for MSDN and TechNet subscribers. The public download is available here . The feature pack download is now also available and includes Report Builder 3.0 as well as the RS add-ins for SharePoint 2007 and SharePoint 2010. The Data Platform Insider blog provides...
  • Blog Post: RS Maps with Spatial Data and Bing Maps

    SQL Server 2008 R2 August CTP includes map visualization functionality in Reporting Services , as briefly described yesterday. In this posting, I’m going to provide an introduction of how to use spatial data and Bing Maps with Reporting Services Maps. The attachment of this posting includes...
  • Blog Post: SQL Server 2008 R2 August CTP – What’s New In Reporting Services?

    The August CTP download is available for MSDN and TechNet subscribers. The public download is now also active here . The Data Platform Insider blog provides an overview of what's new in this first public CTP release for SQL Server 2008 R2. If you are reading my blog, you are probably interested in...
  • Blog Post: Tablix – Multiple Subtotals Are Easy (aka Goodbye InScope)!

    Reporting Services 2005 with Matrix In a matrix in Reporting Services 2005, accomplishing multiple or different subtotal calculations at the same grouping level was difficult, but possible. If you wanted to accomplish custom subtotal calculations in RS 2005, you may have heard about using the InScope...
  • Blog Post: Multi-Player Gaming in RS (aka BI Power Hour 2008)

    At the traditional annual “BI Power Hour” sessions, several teams that contribute 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...
  • Blog Post: SQL Server 2008 SP1 and Report Builder Update

    Service Pack 1 for SQL Server 2008 is now available for download . The service pack is primarily a roll-up of Cumulative Updates 1, 2, and 3 and minor fixes made in response to requests reported through the SQL Server community. While there are no new features in this service pack, a notable addition...
  • Blog Post: Tablix – Stepped Layout

    Tablix enables the separation of data groupings and layout header areas.  A stepped layout can help with horizontal spacing, because nested groups can then share the same horizontal space, which was previously not possible in a matrix layout.  This provides very powerful layout capabilities...
  • Blog Post: Dynamic Drilldown in Reports and Charts

    Just a quick post to reference two interesting reads about designing dynamic drilldown in reports: Sean Boon blogged about an approach to implement drilldown on charts with Reporting Services when Analysis Services is used as the data source. Chris Webb then created a great blog posting on how...
  • Blog Post: Tablix – The Matrix Revolution

    Tablix is the new underlying flexible data region and grouping structure introduced in Reporting Services 2008. Among other features, it enables asymmetric layouts, as demonstrated in the thumbnail screenshot below. If you use a list, table, matrix, chart, gauge, or custom report item in RS 2008...
  • Blog Post: Report Surfer

    I wanted to give some props to MVP Grant Paisley who has setup a site called Report Surfer , where you can directly view, share, and download sample Reporting Services reports. I met Grant a few months back when he visited Redmond. He was very interested in reports I had built for the RS 2005 chart...
  • Blog Post: The Ultimate Guide to Color Scales / Conditional Formatting

    I recently provided a tip to my Australian colleague David Lean to successfully solve a small report design challenge with tables and charts that use conditional formatting. The specific goal was to dynamically calculate and assign a color shade so that the minimum value present in the data is shown...
Page 1 of 2 (36 items) 12