Today my afternoon was spent going through a set of standard reports used by some of the customers that I work with, checking layout, formatting etc. I’d noticed that when a matrix spans over multiple pages, the column headers are not repeated. Foolishly I thought this will be a simple fix, surely just right clicking the group on the group selection at the bottom of report builder, then selecting repeat header… However, sometimes this isn’t the case, turns out you need to dig a little deeper than that! Try this… Select the matrix in question, click the down arrow near...
Continue reading...SSRS
Debugging MDX Queries from SSRS using Profiler and SQL Management Studio
At work recently I came across the need to assess the MDX queries used by some of the reports on our reporting server, along with the parameters that were passed into it (as most of the queries are powered by parameters that are passed into the MDX by parent reports) Unfortunately, you can’t use SSMS to run parameterised MDX queries like you can in SSRS, but the tutorial below gives a good example using SQL Server Profiler, capturing traces of executed queries by SSRS along with the parameter values used. From here you can just paste the MDX into SSMS, replace...
Continue reading...