Davy's Blog

Recently someone asked me to check a Reporting Services report that always resulted in an Unexpected Error. The report server was configured for Sharepoint Integrated Mode.

I came to the conclusion that the server always returned this error after exactly 2 minutes, so it had to be a timeout exception.
The report was kind of big, so [...]

Microsoft has made the sessions presented on SQL Server Day 2009 available on Chopsticks

Opening Keynote by Wesley Backelant and Ritchie Houtmeyers
Best Practices for SQL Server Consolidation by Tom Van Mulders
Breaking the ETL world record with Integration Services by Henk van der Valk
Designing Effective Aggregations in Analysyis Services 2008 by Chris Webb
High availability for BI DWH [...]

Today I wanted to start playing around with the new Report Manager of SQL 2008 R2.
After installing and configuring R2, I opened Internet Explorer and entered the URL of the Report Manager. In my case: http://localhost/reports_r2
I got a very empty Report Manager :

Okay, something is wrong. I tried to connect to http://localhost/reportserver_r2 :

No [...]

Ever tried to change the URL of the Report Manager in IIS using host headers?
I did, but got the following error message when I tried to open the Report Manager:
“The request failed with HTTP status 400: Bad Request”

Today I had some problems with a report solution created in Visual Studio 2005:
After I got the latest version out of SourceSafe, I could not open it anymore. The error message was “Project item ‘4294967294′ does not represent a file.”
Searching for this error on the internet I came to this solution:
- Open the .rptproj [...]

In one of my previous articles I explained how to use embedded code in SQL Server Reporting Services. The possibility to add embedded code to a report, is a very powerfull feature to add some custom functionality to your report.
But sometimes it might be necessary to add some custom functionality that is too complicated for [...]

Sometimes it might be necessary to use the same expression on different places throughout a report. You can of course just copy and paste the expression every time you need it, but if you’ll ever need to change this expression, you will have to change it for every field you’re using it for. Therefore it’s good [...]

Today I had to change an existing report, created using SQL Server 2005 Reporting Services. When I originally created this report a few months ago, there was no problem viewing these reports in the Preview of the Report Designer.
But now the “Select All” was not available anymore in the list of values for parameters defined as [...]