Adding Column headers to Reporting Services Matrix

Posted by beakersoft | Posted in SQL Reporting Services | Posted on 18-03-2007

0


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.

Write a comment

Comments links could be nofollow free.