Friday, 25 February 2011

Problem with modern technology

Just tried to install Team Foundation Server on a collegues machine, only to find that the download from Microsoft is an ISO file...
In an age of USB sticks and drives, our department no longer has CD-R/RW in the office...
As such im having to go off to PC world later...
Or convince IT to allow me to install a ISO mount tool like ISOMagic etc...
Ho hum...
T

Wednesday, 23 February 2011

The first is always the hardest...

It struck me recently that i don't have a place on the web where i can share some of the "work arounds" and "undocumented features that i have found on my travels with Microsofts beloved SQL tools..

So here we are:

Todays snippet, SSRS conditional formatting:

Say you had a percentage field you wanted to highlight if it was a certain value (or range),

For example, I wanted to highlight anything over 15% green I would use the expression:


=IIF(Me.Value >0.15 "LightGreen", "White")


By using the Me.Value namespace, i can copy and past this into whatever placeholder i want, and apply the desired effect hassle free!

Enjoy

T