One of the ‘downsides’ of dynamically creating SQL statements is that you can never tell on beforehand how big your statement will eventually become. This is especially annoying if you have to stay within a maximum number of characters. Fortunately, … Continue reading
Anyone who works with SSIS on a regular basis knows that there are many roads that lead to Rome. A datasource, for example, can be configured in a few different ways. One possibility is by using a parameterized query to … Continue reading
Aside from the default HTML rendering, SQL Server Reporting Services (SSRS) supports rendering extensions as well. You can write your own extension if necessary, or you can use one of the rendering extensions that are included in SSRS. These default … Continue reading
One of the ways to add more flexibility to your SQL Server Reporting Services (SSRS) is to extend SSRS with custom extensions. SSRS supports a wide variety of extensions that serve different purposes, i.e. the custom data extension to manipulate … Continue reading
As promised in my previous post about working with EAV-data this post would about handling multiple timelines (or periods for that matter). While this blog is specifically written for an EAV-environment, the technique explained in this post can be useful … Continue reading