Boxes ! 1

[ianholmes]

I need to display either a blank box,
or a blank box with a tick inside it, on the detail line, depending on the value of a variable.
I thought I could build a function like :

if {?@variable} = 'tick' then
'(box with tick)'
else '(empty box)'

I can get an empty box from the Insert Menu in the main design screen, but not when in Function Design

And how do I get a tick inside a box ?

Or is there a better appraoch ?

 

[Telemachus]

Hi,
I am not sure how feasible this is but
the only solution that I could think of was

1)drag the {?@variable} field into your details section.
2)right click and go to display string(it is found near to the supress check box in the common tab)
inside that
IF {?@variable}='tick' THEN 'A'
ELSE ' '
3) save and come out of the formula editor and change the font of this field to 'Marlett'
4)from the insert menu create a box around this field
you may have to format the box according to the size of the tick that you see

I am not sure whether you have Marlett font available

Please check whether this works else we have to think of something else

Thanks

 

[ianholmes]

Thanks Telemachus : this works great : I had to use lower case "a", & I learned a bit more about Crystal.

 

[ianholmes]

Thanks Telemachus
This works great.
However, I now need to display spaces instead of an empty box if @variable isn't a tick, and I can't apply a formula as above for a drawn box. Is there another approach ?

 

[IanWaterman]

Place formula inside a text box.

In format text box, add a border and then in formula opposite border colour.

IF {?@variable}='tick' then black else white

Should make box disappear when empty.

Alternativley if you have wingdings2 font the letter R is a tick in a box. So change formula and use wingdings2 instead of Marlet

IF {?@variable}='tick' THEN 'R'
ELSE ' '

Ian

 

[ianholmes]

Thanks Ian
Option 2 is best for me.
Can you tell me also how to produce a right pointing arrow, within a blue circlar background ?
This again should be displayed or not, depending on a parameter.
Windings doesn't give such a representation.

 

[IanWaterman]

YOu would need to get an image of what you want as a jpg.

Then use a formula to suppress.
Right click image, format, common.

In suppress formula define your suppression condition

{Field or formula} = suppress condition.

Ian