SQL Reporting "How to" - Conditional Color 1/4: The Basics. Report Expressions & Custom Code

SQL Reporting "How to" - Conditional Color 3/4: Tint & Shade Functions

Dave does Data — Tue, 17 Feb 2009 05:40:03 GMT

This "How to" guide provides ideas & code samples on using color to improve your users understanding

SQL Reporting "How to" – Conditional Color 4/4: Charts & Multi-Dimensional analysis

Dave does Data — Tue, 17 Feb 2009 05:44:16 GMT

Part 4 of 4: Continuous Color functions for Multi-Dimensional analysis (in charts) This "How to" guide

SQL Reporting "How to" - Conditional Color 2/4: Functions for Tables & Charts

Dave does Data — Tue, 17 Feb 2009 05:46:28 GMT

This "How to" guide provides ideas & code samples on using color to improve your users

David Lean shows us how to use conditional formatting in SQL Reporting

Brian H. Madsen - .Net Powered by Caffeine — Tue, 17 Feb 2009 13:43:07 GMT

wow i say!! David Lean has just released an in depth, 4 part series on how to use conditional formatting

The Ultimate Guide to Color Scales / Conditional Formatting

Robert Bruckner's Advanced Reporting Services Blog — Fri, 20 Feb 2009 09:35:32 GMT

I recently helped my Australian colleague David Lean successfully resolve a small report design challenge

re: SQL Reporting "How to" - Conditional Color 1/4: The Basics. Report Expressions & Custom Code

Kasper de Jonge — Fri, 20 Feb 2009 16:28:13 GMT

Great stuff ! nice to see these tips and tricks by the pros :)

re: SQL Reporting "How to" - Conditional Color 1/4: The Basics. Report Expressions & Custom Code

Gedulous — Sun, 22 Feb 2009 16:17:19 GMT

Hi Dave,

This is really nice set of posts here... there's some really useful tips and the stuff from part 4 on color-formatting informationally dense groups of related information is something I can see myself using to great effect. The "By Region" color assignment makes a huge difference to the readability of the pie-chart, and the overall solution is an elegant one.

Have you had a chance to look at any of the PerformancePoint server analytics stuff yet? I suspect a lot of the PPS paradigms would be similar, but applying some of the overall design principles you've outlined to the ProClarity components would be an interesting exercise.

Cheers

Jeremy Huppatz

re: SQL Reporting "How to" - Conditional Color 1/4: The Basics. Report Expressions & Custom Code

Ken — Sun, 03 May 2009 15:57:14 GMT

Excellent post! However, in Tip 3, using a single IIf() might not always avoid the divide by zero error. If the denominator comes from certain database data types (eg. money or decimal) then the single IIf() would still cause an error.

You need to use something described in this post: http://blogs.msdn.com/bwelcker/archive/2006/09/26/End-of-Amnesia-_2800_Avoiding-Divide-By-Zero-Errors_2900_.aspx