Subscribe to this blog
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…
0 comments, 1,194 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…
0 comments, 1,568 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,660 reads
Posted in Advice from Aunt Kathi on 9 March 2007