More help with group formatting please

[Camper66]

Hi Everyone,

I have the following group formula to which I would like to add a conditional image or other type of arrow "---->" if the last condition is true.

I would very much appreciate your help with the exact steps as I am a lay person.

Thank you

if {cr_invoice;1.ITEM_TYPE} = 1 AND {cr_invoice;1.STOCKCODE} <> "FREE" THEN
Formula="Received"
else
if {cr_invoice;1.ITEM_TYPE} = 2 then
Formula="To Crest"
else
if {cr_invoice;1.ITEM_TYPE} = 3 or {cr_invoice;1.ITEM_TYPE} = 4 then
Formula="Ordered"
else
if {cr_invoice;1.STOCKCODE} = "FREE" then
Formula="You Saved"
else
end if
end if
end if
end if

 

[Camper66]

some additional information I should have provided.. The actual formatting formula is currently

IF GroupName ({@Item_type})= "You Saved" then crBold else crRegular

 

[Madawc]

Is this a formula in a variable? You could do it more simply as a formula field

if {cr_invoice;1.ITEM_TYPE} = 1 AND {cr_invoice;1.STOCKCODE} <> "FREE" THEN
  "Received"
else
  if {cr_invoice;1.ITEM_TYPE} = 2 then
    "To Crest"
  else
    if {cr_invoice;1.ITEM_TYPE} = 3 or {cr_invoice;1.ITEM_TYPE} = 4 then
      "Ordered"
 else
    if {cr_invoice;1.STOCKCODE} = "FREE" then
  "You Saved"
else "Other"

If there are problems, dispay this field with the ungrouped data to see what you get.

Your formatting formula should work, but testing the original value would be simpler. Try it.


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

 

[Camper66]

Hi,

The current formula and "BOLD" formatting does work, however I am looking for a way "format" this group with an arrow "---->" or some other graphical image.

 

[Madawc]

Than makes no sense to me. Can anyone else help?

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

 

[lbass]

Create a formula that uses the condition (Crystal syntax used here):

if {cr_invoice;1.STOCKCODE} = "FREE" then
chr(224) //or 240 or 232 (see which you like)

Place the formula on your report and change the font to Wingdings. Then drop your original formula and this formula into a text box.

-LB