Performance issue using formatting in MDX

Posted on Leave a commentPosted in Database, Development, MDX, Reporting Services

To make a long story short – Do not use formatting in MDX when using results for Reporting Services. Here’s a little tip for all who works with MDX and gets stuck on the performance. Sometimes when you work on MDX queries the performance is very slow. This even though the resultset is only a few rows. (I know that the dataintegrity also is a role player here…). But but, I’ve come up with a little finding. If you have used formatting directly in your MDX query in order to get the whole thing done from the SSAS servers power, […]

Picture alignment in SQL Reporting Services

Posted on 8 CommentsPosted in Database, Development, Reporting Services

Ever wondered how to dynamic align pictures in SQL Server Reporting Services? I have for sure needed it often. Untill now I’ve allways answered no to requests for this. The solution can be used when creating reports in SQL Server Reporting Services with dynamic pictures in different sizes based on variables inside the report. In this article the pictures will be aligned right and these are stored in a FileTable on a SQL 2012 instance – you can also do this with other types of picture storage in Reporting Services. Well here it goes: For starters you’ll need a parameter to hold […]