Conditionally place an object!!!

[ssudha]

Hello Friends,
Actually i am stuck with a problem like this.......in generating a report.

I get values(0 or 1) for flag column. I need to place checkbox for flag column. When value is 0 check box unchecked and when value is 1 check box checked. I am trying with two .bmp files but no success.

Kindly suggest some solution to this problem.
Thanks in Advance.

 

[Katy44]

There has been a post similar to this before, I am still looking. It involved using a formula to output a certain letter depending on the 1 or zero, and then changing the font of that formula field on the report to Wingdings - which gives the check box, checked or unchecked. I'll see if I can find it.

 

[Katy44]

http://www.tek-tips.com/viewthread.cfm?SQID=806421&SPID=766&newpid=766&page=4

 

[ssudha]

Hi,
Thanks for the prompt reply,.....atleast i got some direction to go about.......let me check with this...

If u come across some solution to the same, please respond immediately.
Thanks.

 

[Katy44]

It seems you just need to create a formula:

if {table.field} = 1 then 'x' else chr(254)

put that formula on the report and change the font to Wigdings.
I'll give it a go to see if it works for me.

 

[Katy44]

Ah it gives you a tick and a cross,

if {table.field} = 1 then 'x' else 'o'
is almost there - the boxes don't come out the same size

 

[lbass]

Try:

if {table.field} = 1 then
chr(254)
else
chr(168)

The formula must be formatted with the wingdings font.

-LB

 

[ssudha]

Hi,
I am using Business Objects 6.1b and i am getting empty checkbox and a checkbox with a cross in it for characters "o" and "x".
I need tick mark....Any help.

 

[ssudha]

Hi Friends,
This is working perfectly for me.....
= If (<Flag>="1") Then Char(254) Else Char(168).

But if i export it to PDF i see some junk characters....
Excel is ok (fonts are supported).

Any other possibility of conditionally placing the objects in the cell