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

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

Hasan Jamal Siddiqui — Tue, 09 Apr 2013 08:21:39 GMT

Nice blog,But can you explore also how to highlight color for text only

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

Mahboob Alam — Tue, 26 Jun 2012 11:57:07 GMT

devdex.wordpress.com/.../sql-server-reportingapply-checks-on-report-fields

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

Mike — Tue, 20 Mar 2012 21:17:25 GMT

Great post for conditional formatting!! If I export a report to Excel, how can I get the conditional formatting to export/transform into Excel conditional formatting?

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

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

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

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

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

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

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

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