Conditional Statements

ChounminChounmin Junior Member
edited December 31, 1969 in Designing Analytics Reports
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

Comments

  • VirgilVirgil Administrator EM admin
    edited December 31, 1969
    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.

    Virgil Dodson
    OpenText Analytics Developer Community
    https://forums.opentext.com/forums/categories/analytics

  • ChounminChounmin Junior Member
    edited December 31, 1969

    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.






    Thanks for the instructions. But when the report is generated, 1 row for each column.



    Suppose a person has record for 2 courses, I will see 2 rows.
  • VirgilVirgil Administrator EM admin
    edited December 31, 1969
    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:



    http://www.birt-exchange.com/modules/wfdownloads/singlefile.php?cid=2&lid=344

    Virgil Dodson
    OpenText Analytics Developer Community
    https://forums.opentext.com/forums/categories/analytics

Sign In or Register to comment.