Musings on Data

A blog for data, apis, and all things Power BI by Lukasz Pawlowski.

February, 2006

  • Musings on Data

    Upgrading Reporting Services - What about my Report Definitions (RDLs)?

    • 1 Comments
    Some folks have asked me what happens when I upgrade my RS 2000 to an RS 2005 deployment with respect to Report Definitions (RDLs). This is an interesting lifecycle problem that we’ve approached using the following idea: What you publish to the report server is what you retrieve from the report server. Here’s how it works: Say you have an RS 2000 Reporting Services deployment that has a number of working reports in it. You probably have one or more corresponding report projects that you edit in Report Designer in Visual Studio 2003 .Net. When you publish these reports, the RDL is stored in the Report Server Database (not the file system!). The RDL is stored and we create a corresponding compiled version of the report that we also store...
  • Musings on Data

    Populating the Cache before your users pound your report server

    • 1 Comments
    Often people take a look at their report execution times and wonder how to optimize it. They readily see that it is possible to cache a report the first time a user runs it so that subsequent users don't have to incur the initial execution time. Well that still leaves the first person to take the 'pain' of waiting for the report to run. If yours is like many organizations, the 'first person' is actually a race right at 8am to see who clicks the report. Many folks end up waiting through that initial report execution time. Luckily, there is a feature of reporting services that allows you to solve this and prepopulate the cache before your users show up to click the report. Before we get to the solution, a little background. There...
Page 1 of 1 (2 items)