Conditional Statements

Chounmin

I have a table which contain some records on the training activities. I would like to generate a simple report to display as below

Name Designation Excel Word Access
Tan Clerk X X
Lim Sec X X X
David admin X X

I have created an expression here

if (row["excel"] == "excel"){ X}
else if (row["word"] == "word"){X}
else {X}


It is not displaying anthing. Please help

Virgil Dodson

Hi Chounmin,

Where is your Expression located? If you are trying to replace the word "excel" with the letter "X" when it occurs in a field, then you can do this on the Mapping tab in the property editor of a cell.

Chounmin

<blockquote class='ipsBlockquote' data-author="vdodson"><p>Hi Chounmin,<br />
<br />
Where is your Expression located? If you are trying to replace the word "excel" with the letter "X" when it occurs in a field, then you can do this on the Mapping tab in the property editor of a cell.</p></blockquote>
<br />
<br />
Thanks for the instructions. But when the report is generated, 1 row for each column.<br />
<br />
Suppose a person has record for 2 courses, I will see 2 rows.

Virgil Dodson

You can combine the rows by adding grouping to the table that groups on NAME. Select hide details in the group settings and then use the aggregation wizard from the palette to count the number of "excel"m 'word", etc. I created a quick example that does this and uploaded it to:<br />
<br />
<a class='bbc_url' href='http://www.birt-exchange.com/modules/wfdownloads/singlefile.php?cid=2&lid=344'>http://www.birt-exchange.com/modules/wfdownloads/singlefile.php?cid=2&lid=344</a&gt;