Davy's Blog

Reporting Services 2008 is a great reporting tool, but displaying Analysis Services data with Reporting Services doesn’t always display the data as you would expect. A Parent-child hierarchy is one example of this: When you browse Parent-child hierarchy from an Analysis Services cube with Excel, Excel automatically displays it with nice drill-down functionality. But when [...]

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 [...]

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 [...]

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 [...]

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 [...]

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 [...]