Traffic Lights or the like

[DeviousDi]

Hi All,

Quick question! Apart from the conditional formatting, does CRXI for SAP have any traffic light system, or anything like it?

I'm creating a dashboard and just want it to look a bit different rather than 'blocks' of colours, or coloured text!

Any 'snaffly' ideas to make it look better would be welcome!

Thank you,

Di

 

[Madawc]

Right-click on a section and get Section Expert. Then go to the Colour tab.

You can set a background colour, and also make it dependant on a formula. (That's accessed by the X-2 box next to the colour choice.

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP

 

[pmax9999]

I have used some of the Wingdings character set, such as the Thumbs Up / Thumbs Down, Tick / Cross to indicate good / bad results. When combined with colors (eg Green for good, Red for bad) you can get quite good results.

For example, to create the Thumbs Up for a good result or a Thumbs Down for a bad result, create the following formula, place it on the report and change the Font to Wingdings:

If	{Table.Field} >= [i][Desired Result][/i]
Then 	Chr(67)
Else 	Chr(68)

A list of the CHR numbers can easilly be found with a quick google search.

Colours can be controlled with Conditional formatting of the formula field.

Hope this helps.

Cheers
Pete