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: 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: 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: Kerberos Authentication and SharePoint 2010

    A new whitepaper for Configuring Kerberos Authentication for SharePoint 2010 products has just been released.  Section 4 of that whitepaper specifically explains identity delegation for Reporting Services.  The whitepaper also covers SQL Server Analysis Services, PowerPivot, Performance Point...
  • 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 R2 Resources

    SQL Server 2008 R2 was released to manufacturing on April 21, 2010. You can read more about it here . RTM downloads already available: Report Builder 3.0 RTM SQL Server 2008 R2 RTM - Developer Trial Edition SQL Server 2008 R2 RTM - Express Edition with Advanced Services SQL Server 2008...
  • 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: Reporting Services 2008 R2 SharePoint Integration

    My esteemed colleague Prash Shirolkar put together blog postings with helpful tips for: Integrating Reporting Services 2008 R2 with SharePoint 2010 Integrating Reporting Services 2008 R2 with SharePoint 2007
  • 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: 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: 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 in SharePoint 2010, Access Services

    Besides releasing Reporting Services in SQL Server 2008 R2 , we were busy working on a number of improvements for the Reporting Services SharePoint Add-in as well. SharePoint 2010 Reporting Services Add-in The SharePoint 2010 pre-requisite installer now automatically guides you to download and install...
  • Blog Post: Visual Studio 2010 Report Viewer Available

    In case you missed it in the recent wave of SQL Server, Visual Studio, and Office release announcements, Visual Studio 2010 was released in mid April and includes significantly enhanced ReportViewer controls. In server mode, the ReportViewer control can connect to and leverage the features of SQL Server...
  • Blog Post: SQL Server 2008 R2 RTM

      SQL Server 2008 R2   was just released to manufacturing (RTM) today. You can read more details about the overall SQL Server 2008 R2 release here .   SQL Server 2008 R2 is a big release, with new “editions” (MSDN contains the detailed feature by edition matrix ), and includes also...
  • 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: Report Builder 3.0, November CTP

    A small stand-alone MSI for Report Builder 3.0, November CTP, is now available for download here . For a list of feature additions in November CTP, please refer to my previous blog post .
  • 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: Reports As Data Feeds for PowerPivot

    Donald Farmer explains in this one minute video how report data feeds (“the orange button”) are simply great data sources for further analysis in PowerPivot. You get the benefits of both, Reporting Services as platform with all its reporting and management features (e.g. role-based security, cache refresh...
  • Blog Post: Report Builder 3.0, August CTP

    A small stand-alone MSI for Report Builder 3.0, August CTP, is now available for download here: http://go.microsoft.com/fwlink/?LinkID=160384 Download packages for SQL Server 2008 R2 August CTP are available here: http://www.microsoft.com/downloads/details.aspx?FamilyID=e19689bd-38dd-46c4-8645-f58ca4d61d1f...
Page 1 of 2 (29 items) 12