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 for Multidimensional Models Released!

    I am excited about SQL Server 2012 Service Pack 1 Cumulative Update 4 , released today, which provides the ability for customers to create Power View reports against their existing multidimensional models (a.k.a. cubes). SQL Server 2012 Service Pack 1 Cumulative Update 4 contains a few additional enhancements...
  • 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: Reporting and SQL Data Services

    SQL Data Services (SDS) was shown at PDC in October, utilizing a REST based interface. As described in a previous posting , we also made available a SDS custom data extension for Reporting Services reports. A few days ago, we announced that besides the REST interface, SDS will also expose SQL Server...
  • Blog Post: Using Teradata's .NET Data Provider

    Reporting Services 2008 RS 2008 includes full support for Teradata-based report models. You can create and use semantic models based off Teradata similar to how Reporting Services already supports this for SQL Server, Analysis Services, and Oracle. Furthermore, RS 2008 includes a Teradata data extension...
  • Blog Post: Reporting from Data in the Cloud (aka SSRS and SDS at PDC)

    One of the demos shown at Monday's PDC keynote by Ray Ozzie and Bob Muglia was Reporting Services with data stored in SQL Data Services (SDS) in the cloud. Besides the keynote, there are several more sessions throughout PDC featuring Reporting Services - building those demos was a lot of fun! How...
  • Blog Post: What DataSet Query Text Is Executed?

    In a previous posting, I discussed dataset execution order in Reporting Services. In this posting, I will provide a few tips for situations where you or your report users are wondering what is the actual query executed by Reporting Services. While you can accurately answer this question using a profiler...
  • Blog Post: Using Analysis Services Parent-Child Hierarchies in Reports

    One of the questions that I answer somewhat frequently, is about recursive groupings in Reporting Services and how to utilize parent-child hierarchies from an Analysis Services cube. The attachment of this posting contains a small report example I put together based on the Analysis Services 2005 Adventure...
  • Blog Post: Dataset Execution Order

    A Reporting Services report can contain multiple dataset definitions. By default, datasets are executed in parallel . Now, in some situations you may not want this parallel query execution behavior - for example: Your data source system cannot handle too many parallel connections. You are executing...
Page 1 of 1 (8 items)