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: Reporting Services 2008 Service Pack 2

    SQL Server 2008 SP2 provides a roll-up of previous cumulative updates and also contains enhancements for Reporting Services SharePoint integration. Report servers with SP2 can integrate with SharePoint 2010 products. SP2 also provides a new add-in for integrating with SharePoint 2007 products. In addition...
  • Blog Post: PivotViewer for Reporting Services

    PivotViewer for Reporting Services makes it easier to interact with parameterized reports and large amounts of data in ways that are powerful, informative, and fun. You decide at runtime which subset of data you want to look at and what (meta)data you associate with each card. You can now download...
  • 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: Kerberos Troubleshooting

    Adam Saxton posted his great Kerberos troubleshooting guide, which covers both Reporting Services in native mode as well as SharePoint integrated mode configurations: http://blogs.msdn.com/b/psssql/archive/2010/06/23/my-kerberos-checklist.aspx If you are specifically troubleshooting Kerberos with a Reporting...
  • Blog Post: Debugging Custom Extensions with Visual Studio 2010

    If you are developing custom extensions for Reporting Services (such as a data processing extension, delivery extension, security extension, rendering extension, report definition customization extension) with Visual Studio 2010, you have to make sure you compile the extension for the .NET 2.0/3.5 CLR...
  • Blog Post: Reporting Services 2008 Resources

    Get an overview and the latest information on Reporting Services 2008 at the MSDN aggregation page for Reporting Services ! Research and ask questions on the updated MSDN forums for Reporting Services . Important downloads for Reporting Services: SP2: Report Builder 2.0 ( SP2 Download ) for...
  • 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: Kerberos Authentication and Reporting Services

    When deploying Reporting Services in an environment that requires more than one server, such as a scale-out deployment or a deployment in a server farm, you may need to configure Kerberos authentication. Kerberos is particularly important when you require domain accounts to authenticate users but don...
  • 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: 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: Reporting Services Books

    A short list of my personal recommendations for the latest Reporting Services books. Disclaimer: I read all these books, and in most cases performed partial or complete technical reviews of the contents, and provided material contributions to some. Reporting Services 2012 books: Professional...
  • 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: SharePoint Integrated Mode

    Chris Alton’s whitepaper on Reporting Services SharePoint Integration Troubleshooting is now available on MSDN. It provides a great set of configuration tips, diagnosis, and troubleshooting instructions. The following two older Reporting Services 2005 SharePoint Integrated Mode related whitepapers...
  • 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: Subreport Usage

    In a previous post I showed how to quickly find reports that use custom report items (CRIs). The same idea can be applied to subreports as well. As an administrator of a report server, you may access the catalog database directly. Keep in mind that any queries you execute directly against the report...
  • Blog Post: RS Tracer

    Have you ever wondered what API calls Report Manager or Management Studio are performing to accomplish certain operations?  Teo Lachev’s RsTracer helps answer these questions.  The tool is available as a CodePlex project and shows the APIs that a Reporting Services client invokes and what arguments...
  • 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...
  • Blog Post: BIDS Helper, RS Scripter

    I wanted to point out two Reporting Services utilities built by our MVPs and user community that you may find very useful. BIDS Helper is a CodePlex project: http://www.codeplex.com/bidshelper In past releases, the focus has been on significantly enhancing Analysis Services and Integration Services...
Page 1 of 3 (54 items) 123