Adding Column headers to Reporting Services Matrix
Posted by beakersoft | Posted in SQL Reporting Services | Posted on 18-03-2007
1
Found out a very useful tip (thanks to Bob at Microsoft – http://blogs.msdn.com/bobmeyers/) that allows you to add a heading to a column in a SQL reporting services Matrix.
You simply need to add a new column group to the top of your Matrix, and set its expression to be something like ‘DummyExpression‘, and make sure you omit the normal leading ‘=’, like below:

Now, you can move the group to be the top one in the properties of the Matrix, and type in the text box what ever header you need.
Simple but effective, I didn’t even realise you could put dummy data into an expression, I thought the IDE would kick it back
On an entirely different note, I was very excited(being the big geek I am) to discover today that Buffy the Vampire slayer season 8 is coming back in comic book form, and is written by no less than Joss Whedon himself!
Check it out at Dark Horse comics here http://www.darkhorse.com/
I cant wait till my next visit to the comic shop!
Listening to: Saves the Day, Stay what you are. 

This Blog about my (mis)adventures in the IT industry. My aim is to update this blog as often as possable with any tips, news or rants I might have. You can reach me at luke@beakersoft.co.uk


Joss Whedon is a great director, most of the science fiction series that i love are created by him.’,*