How to export a report to excel with Yes/No data Types? 1

[Cero21]

I am trying to export a report into excel but my field that have yes/no datatypes do not appear in the spreadsheet. Any way to make this work? Thanks!

 

[jozino01]

well, normally they appear as TRUE/FALSE or 1/0 in excell.

 

[Cero21]

It does appear in the spreadsheet as true/false when I export the table but not as a report.

 

[misscrf]

Then in the report, create an expression in the query builder...

Make a field for what you want it to look like:

MYTrueFalse: IIF(TruFalsField = 1, "True", "False")

That should do it. TruFalsField is the field in your table, shown in the query builder, that stores the true/false value.

Make sense?

misscrf

It is never too late to become what you could have been ~ George Eliot

 

[Cero21]

misscrf:

Thanks for your quick reply. I tried what you suggested and brought the new field into the report. When I try to export the report to excel the new field doesn't appear as well as the original one.

 

[misscrf]

Did the formula at least work to show what we wanted it to, in the preview of the report?

Another try might be to take the query for your report, and do a make table (so you keep the original intact) and use that formula to change the checkbox to a text box with that new format...

misscrf

It is never too late to become what you could have been ~ George Eliot

 

[Cero21]

Thanks for your help misscrf.

I found a solution without using the query builder. I simply put the expression you gave me into a new field in the report like this:
= IIF(TruFalsField = -1, "True", "False")

Worked like a charm.

 

[misscrf]

excellent!

misscrf

It is never too late to become what you could have been ~ George Eliot