SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Advice from Aunt Kathi

Kathi Kellenberger is a Sr. Consultant with Pragmatic Works. She is an author, speaker and trainer.

Archives: March 2007

Conditional formatting in Reporting Services

Yesterday's post reminded me of another interesting technique I have used to change the color of the values on a report based on a range. Let's say I wanted the color of a field to be black if the value was between 0 and 10, blue if between 11 and…

Read more

0 comments, 1,295 reads

Posted in Advice from Aunt Kathi on 11 March 2007

Using IIF in Reporting Services

I found an interesting use for the IIF function in a Reporting Services report this week. I needed to provide a report of users and the schedule date for migrating them to our new workstation image or the date that they were migrated. The people viewing the report are mostly…

Read more

0 comments, 1,678 reads

Posted in Advice from Aunt Kathi on 10 March 2007

SQL Server Learning Opportunities!

There are two big SQL Server learning opportunities I want to remind you about.  First, DevTeach/SQLTeach will be held in Montreal May 14 - 18.  I will be speaking there this year on beginning T-SQL and new T-SQL features of SQL Server 2005.  The second talk will cover error trapping,… Read more

1 comments, 1,774 reads

Posted in Advice from Aunt Kathi on 9 March 2007