Welcome to EMC Consulting Blogs

In October 2009 I created 2 codeplex projects which I would to tell you about: SQL Server Reporting Services MSBuild Tasks (ssrsmsbuildtasks) A few years ago I created some tasks for MSBuild to help deploy reports for my project, details can be found here,  since then my tasks have been re-used in a few other projects within my ...

I have been working with Microsoft SQL Server Reporting Services, since its first release, within many of my projects.  One of the biggest tasks, that I find with writing a report is the testing the reports and making sure the data that is displayed is correct.  My method of developing and testing reports is as follows: Write the ...

[Every time I come across this problem I seem to spend a good five minutes scanning the interwebs trying to find the answer - maybe if I write it here it'll be easier to find in the future!] SQL Server Reporting Services 2008 has a bug concerning the FixedColumnHeaders property of a tablix. The property's description is given as ...

As I have mention in a previous blog entry I’ve been heavily involved in the Scrum for Team System process template since the start of version 2 and have written the majority of the reports. I have faced, and still do, some challenges while doing this. Some of them have been around how to display the data within reporting services 2005. ...

I have been working on a POC using SQL Server 2008 and Google Maps.  The POC was to use Geo Spatial technology to illustrate our Geo Spatial data easily.   I will talk about this in more detail in another blog post as I would like talk about a problem I faced while creating this POC.  The problem I faced was how could I get ...

Came across a weird ‘feature’ last week to do with a table field report causing a java script error on the page with the error message ‘Children.0.Style is null or is not an object’.This appears to occur if you have more than the left most column set to fixedheader = true.If you set ALL the columns to fixedheader = true you ...

I came across a weird ‘feature’ last week to do with a table field report causing a java script error on the page with the error message ‘Children.0.Style is null or is not an object’.This appears to occur if you have more than the left most column set to fixedheader = true.If you set ALL the columns to fixedheader = true ...

This question that has come up a few times on the project on which I am currently working.‘How to ensure that Sub Report data in Reporting Services is included when exporting to XML and CSV formats?’This is not the default behaviour of RS but luckily the answer is very simple.Right-click on your sub report and select properties.Note ...