Conditional Statements
Options
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
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
0
Comments
-
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.Warning No formatter is installed for the format ipb0 -
<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.0 -
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>Warning No formatter is installed for the format ipb0
Categories
- All Categories
- 111 Developer Announcements
- 49 Articles
- 103 General Questions
- 123 IM Services
- 40 OpenText Hackathon
- 31 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 897 Cloud Fax and Notifications
- 77 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 123 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management
- 1 XM Fax