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

I recently struggled with the following challenge in Analysis Services:
In one of the fact tables there was a field duration which actually was a duration of a certain status in seconds. I needed to display this in a readable format, like “2 days 22:15:59″.

bing brought me to the following great article, where Mosha explains how [...]

After installing SQL Server Integration Services on an existing 64-bit SQL Server, I was unable to connect to SSIS using Management Studio.
The database engine and Analysis Services was already installed on this server. I added the SSIS service without Service Pack and applied SP3 afterwards. When trying to connect, Management Studio returned the following error [...]

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

This event is brought to you by InfoSupport and handles the implementation of BI within a SAAS concept.
Agenda Oscar Zonneveldand and Josquin Booij from InfoSupport will discuss the following topics:

1. The Business Case2. The Functional and Technical Architecture3. Near-realtime BI4. The Real world
About the speakers
Oscar Zonneveld is a BI and Datawarehouse Architect at Info Support’s [...]

I justed wanted to share this interesting article:
With new compression, partitioning and star schema optimization features,Microsoft’s SQL Server 2008 is catching up with the state of the industry in data warehousing.Here’s why these three capabilities are crucial for scalability and performance on any platform.
By Warren Thornthwaite

Read the full article here.

Today I got this error while trying to browse a cube from the Business Intelligence Development Studio:

The detailed error information told me that the connection failed, because the server actively refused it. Connecting from another pc worked perfectly, so it had to be a problem with my computer.
To solve this problem I needed to reinstall the [...]

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