Colouring variables

[redeemasp]

I've a straightforward if

if isnull({ORC_get_O07MarketingLead.Description}) then
(
strMarketingindicator := "No"
)
Else
strMarketingindicator := "Yes";

Wanting to colour in Crystal according to yes or no.

I tried color (R/g/b) no luck. Is there another way?

Redeem.

 

[PatrickIRL]

if isnull({ORC_get_O07MarketingLead.Description}) then
(
strMarketingindicator := "No"
)
Else
strMarketingindicator := "Yes";

add this ...

if strMarketingindicator = "No" then
    Red
else
    Black;

Hope this helps,

Patrick

 

[redeemasp]

How would that work if you have a shared variable that you could not distinguish.

e.g. if you had a number that was only distinguish when you see if its a null e.g.

If isnull({ORC_get_O31NetSales.NetSales}) then
(
numRevenue := "£" & totext({AMGR_Opportunity.Forecast_Revenue});
// Black;
)
Else
(
numRevenue := {ORC_get_O31NetSales.NetSales};
// Blue;
);

?

 

[lbass]

You don't need to use variables here. First, you should handle nulls before applying color, since null fields cannot be formatted with color. So for example, create a formula {@netsales}:

if isnull({ORC_get_O31NetSales.NetSales}) then
{AMGR_Opportunity.Forecast_Revenue} else
{ORC_get_O31NetSales.NetSales} //assuming they are both numbers

Then right click on {@netsales}->format field->font->x+2 and enter:

if {@netsales} = {AMGR_Opportunity.Forecast_Revenue} then crBlack else crBlue

-LB