Ask Your Question
1

Is it possible to link a boolean field to an image

asked 2020-03-31 18:12:21 +0200

ralf.kof gravatar image

I would like to do this so that the output on a report is an image rather than a word (ex. true/false)

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2020-03-31 18:16:13 +0200

Ratslinger gravatar image

updated 2020-03-31 20:58:30 +0200

Hello,

Please see my answer in this post -> Conditional format for boolean in report

Edit:

For an actual image, include a link to the image in the record (embedded images in reports have been a long standing problem). Then use a conditional print expression (General tab of field property):

["myBool"]="true"

where myBool is the boolean field to check.

Sample result:

image description

Edit #2:

Also, if the image is constant, you can simply insert in using properties (Graphics property):

image description

edit flag offensive delete link more

Comments

What if I need it to show an image instead of a character?

ralf.kof gravatar imageralf.kof ( 2020-03-31 19:13:31 +0200 )edit

How do I include a link to the image in the record? do i add another field in the table for that? or another table? Sorry, I am very new to these stuff. I only learned about base through thefrugalcomputerguy.com.

ralf.kof gravatar imageralf.kof ( 2020-04-02 12:15:49 +0200 )edit

NVM, I've figured it out thru multiple tries. And I am very much thankful for the answers you've given me. You're solution only works if both your answer (the link and your post) was combined. Adding an "if" function in the data field in the data tab, then afterwards inserting an image with the conditional print expression you suggested made it work for me. Thank you so much.

ralf.kof gravatar imageralf.kof ( 2020-04-02 13:31:55 +0200 )edit

@ralf.kof,

Glad all is working. Sorry if clarity was not there.

Ratslinger gravatar imageRatslinger ( 2020-04-02 17:35:16 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-03-31 18:12:21 +0200

Seen: 39 times

Last updated: Mar 31