How to display boolean parameter in words?

All,
Thanks in advance for responding to this newbie post. I am working through the tutorial and have created a report driven by a stored procedure. All is going find except that one of the input parameters to the stored proc is a boolean. I'm displaying it in the header of the report but it displays as "true" or "false". How can I display it in a more user-friendly format, like "Yes" or "No".
Thanks!

Find more posts tagged with

Comments

Ilya

You can use MAP function, select the cell you want to translate and select 'MAP' in the property editor.

AustinJim

Thanks for the reply but I can't find MAP in the property editor. Which tab is is on (General, Padding, Border...)?

Ilya

bhanley

This DevShare sample shows mapping both via the data item (in-line expression) and using Cell Maps (as Ilya pointed out). Give it a go. It should clear everything up for you. 
 
<a class='bbc_url' href='http://www.birt-exchange.com/devshare/designing-birt-reports/805-data-mapping-example/#description'>Data mapping example - Tips & Tricks - BIRT Exchange</a> 
 
Good Luck.

AustinJim

I tried to load the sample report but a message is displayed saying report version 3.2.17 is not supported. I'm running the BIRT all-in-one Eclipse installation version 2.3.0. The rptdesign is still opened in the designer so I can see the XML if that's helpful.
Any suggestions?

mwilliams

AustinJim,

If you change the version information in the XML to your version information, you should be able to run the report then.

AustinJim

That example and everyone's help provided me just what I needed. Thanks!

Tripathi

hello,

when i opened the FieldMapSample.rpt in my eclipse desginer I was getting the same error pointed by Austin.

then i changed the xml version name in xml source
From :<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.17" id="1">

To : <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.15" id="1">

but still it was giving me following error msg

" error in xml source page must be corrected before other pages can be used."

thanks in advance