In a previous post, I wrote about how to prevent the divide by zero issues in Reporting Services. The problem with the custom code I used was that the code returned the value 0 when one of the numbers is 0 or unknown. So when the outcoming was NULL, the code returned 0. This result in
A common question in the Business Intelligence world from customers is “how many customers did we lose this year” ? Businesses wants to know this so they can act faster to keep customers doing business with them. In this article, I will help you to create SQL to calculate
Making Sense of Data Do you work with surveys, demographic information, evaluation data, test scores, or observation data? Are you interested in making the data you collect more useful by organizing it, analyzing it, and applying it in different ways? This self-paced, online co
Sqlblog.nl exists 4 years now and I thought it was time for a new design and logo for Sqlblog.nl. Today I am proudly to present the new Sqlblog.nl Logo, thanks to KeviG for his effort. I hope you like it. I also did some new styling to the site to make it more user friendly.
I am working for a client which uses a Datawarehouse in which the data is loaded once a day during the night. During the rest of the day, nothing changes in the datawarehouse. After a couple of years, the database grows and grows and reports are getting slower and slower. Another prob
Sounds easy right? I want to calculate the difference in hours and minutes between two dates. A good readable notition for my report. I want a format like this: 00:36:53 OR 02:13:45 This can easy be done using a T-SQL Statement like this: CONVERT(nvarchar(64), EindDatum-S
I was looking for a method of formatting a dimension attrbibute in SSAS2008R2 to, for example a currency symbol €. In search of this question, I found out this is not possible within the default SSAS settings (format column). I thougt this was possible just like the measures settings
Microsoft heeft leuk nieuw speelgoed geintroduceerd genaamd Power BI. Het ziet er veelbelovend uit, al heb ik nog niet de mogelijkheid gehad om ermee te testen. Origineel artikel van de Microsoft website Hier nog een artikel op computerwereld.
Als je in SSRS2008R2 een rapport maakt en je wilt dat de bovenste header vast blijft staan als je naar beneden scrollt dan zal je normaal gesproken verwachten dat de optie “Keep header Visibile While Scrolling” dit regelt. Niets is minder waar. In SSRS2005 werkte deze opti