Keeping your report servers awake (or No more waiting for report server to startup)

Update 5/3/2010: With time and experience, we learn.  So of course an easier way exists to do what this blog post states.  Just set the Idle Time-out to zero  on the Application Pool configuration.  Bill Staples gives the UI snapshot of where to make the change here: HTH.   Reporting Services in SQL 2005…


Scale Testing Reporting Services

I wanted to provide a quick note on how to scale test Reporting Services.  Partially I’m posting this so I don’t lose the link :-). Often we are asked how best to scale test Reporting Services and what scale numbers to expect coming from a particular configuration.  We always hesitate to promise specific numbers because…


Report Viewer Control – Reset() method

This post is about a consequence of the calling ReportViewer.Reset() method related to revaluating parameter default values.    The Report Viewer controls are a great way to integrate reports into your applications.  You can see some examples here: One aspect of using the controls that may not be easily found/understood is the value of the Reset() method.…


Monitoring Subcription Status – New reports!

A while ago I wrote a blog post to explain how to monitor subscription status.  You can read it here: Today, I updated the Subscriptions List report contained in that entry and published to enhance its functionality. I also added 3 reports that will help you see which subscriptions use which delivery extension. You can get the reports here: New…


New Reporting Services Portal on MSDN

Just adding a quick note about the new MSDN Home Page for Reporting Services.  It has links to many great pieces of content including articles, blogs, Webcasts, and references to online docs.   Take care and good luck, -Lukasz


Using Multi-Value Parameters Programmatically

It seems there is a ton on confusion about how to programmatically use multi-value parameters. Here’s how to do it using the SOAP API for report execution: Here’s how to do it in subscriptions: Here’s how to do it using expressions inside a report: Now, just for your inner geek, here’s a treatment…


Reliability through isolation

Reporting Services is an example of a system that both handles interactive user load and schedule load.  It is also allows interactive users to schedule reports.  A poor scheduling decision on the part of one user can can have significant impact on the overall responsiveness and reliability of your Reporting Services deployment.  As an administrator when…


Daylight Savings Time issues with Notification Services – update your databases!

With the coming change to Daylight Savings Time in the United States, you will need to update your NS application databases for NS v2 and NS v2 SP1.  For SQL Server 2005 NS, you will need to update your databases for existing applications. SQL Server 2005 SP2 contains a fix to ensure new applications created…


How to diagnose issues when running reports in the report server?

A customer came to the SQL Server Customer lab to investigate a problem with one of the feature I’m responsible for – data-driven subscriptions.  In looking at their solution, we discussed any number of problems they had encountered.  I realized that it can be difficult to find out where to start looking when a problem…


Per user snapshots? Or multiple snapshots for a report each with different parameters at the same time

I’ve received questions in the past about whether the report server supports per user snapshost – that is report snapshots customized with different parameter values for a given user.   The answer I have always given is no – you get one snapshot per report and that snapshot always uses the default parameter values. Well, it…