Source language: Translate to:

Printing yes-no fields

Questions about our Advanced Database plug-in

Moderator: Neosoft Support

Printing yes-no fields

Postby carlos torres » Tue Jan 29, 2013 9:59 am

Dear NB Team
TIA
Is there any way to print in a report an 'X' in a yes/no field instead of the word 'true/false' ?
Or I have to change the field definition changing a boolean field for a string one?

regards
carlost
User avatar
carlos torres
 
Posts: 289
Joined: Mon May 02, 2005 8:14 am
Location: Pamplona, Colombia

Re: Printing yes-no fields

Postby Neosoft Support » Tue Jan 29, 2013 10:52 am

You can try using the formatting option of the Report Designer's Text/Field tool. I the caption, enter an "X", then click the formatting button. Set the condition to something like this:

[Table.Field] = False

Then set the font color to white or whatever the background of your report is.

This should display an "X" when the value of the field is true and nothing when false.
NeoSoft Support
Neosoft Support
NeoSoft Team
 
Posts: 5603
Joined: Thu Mar 31, 2005 10:48 pm
Location: Oregon, USA

Re: Printing yes-no fields

Postby carlos torres » Tue Feb 05, 2013 11:11 am

Dear NB Team

Thanks for your quick answer.

I'm trying to develop a little app to record the dental history and I have to ask some previous conditions like heart stroke or similar conditions.
Your solution looks good at a first glance but I didn't get the expected result.
I know that it is almost a no-brain action but for any reason it doesn't work for me. Probably I'm missing something

1 - On the caption of the text/field I put an 'X'
2 - On the conditional formatting value I put '[DentalHistory.Diabetes]=FALSE'
3 - On Font and Fill color section both are white

It allways shows the 'X'. I don't know what I'm missing
I will appreciate any help

regards,
carlost
User avatar
carlos torres
 
Posts: 289
Joined: Mon May 02, 2005 8:14 am
Location: Pamplona, Colombia

Re: Printing yes-no fields

Postby Neosoft Support » Tue Feb 05, 2013 11:18 am

You have to put quotes around "False" in the formatting code. For example:

[DentalHistory.Diabetes] = "FALSE"

Sorry, I forgot about that.
NeoSoft Support
Neosoft Support
NeoSoft Team
 
Posts: 5603
Joined: Thu Mar 31, 2005 10:48 pm
Location: Oregon, USA

Re: Printing yes-no fields

Postby carlos torres » Wed Feb 06, 2013 3:17 pm

Dear Team
TIA
I'm Sorry it doesn't work even using quotes.
I don't know how to post an image to show you what I'm doing.

Regards
carlost
User avatar
carlos torres
 
Posts: 289
Joined: Mon May 02, 2005 8:14 am
Location: Pamplona, Colombia

Re: Printing yes-no fields

Postby Neosoft Support » Thu Feb 07, 2013 10:51 am

NeoSoft Support
Neosoft Support
NeoSoft Team
 
Posts: 5603
Joined: Thu Mar 31, 2005 10:48 pm
Location: Oregon, USA

Re: Printing yes-no fields

Postby carlos torres » Thu Feb 07, 2013 2:48 pm

Dear Team

Thanks for the sample.
The condition of the formatting formula is CASE SENSITIVE !
I was using "FALSE" and it must be "False"
Code: Select all
.../// this is the right way !
[DH.Diabetes] = "False"

Thanks again for your time

regards
carlost
User avatar
carlos torres
 
Posts: 289
Joined: Mon May 02, 2005 8:14 am
Location: Pamplona, Colombia


Return to NeoBookDBPro

Who is online

Users browsing this forum: No registered users and 3 guests