|3 data columns, one cell and IF statements? [message #1016787]
||Thu, 07 March 2013 11:57
| Steve Brown
Registered: March 2013
I am converting a report into BIRT and have come across a field that in the old report seems to have an if statement to determine what data is displayed. The statement is saying:
If data in database column customerid does not equal '' (blank, not NULL) then display the data from column customerid...
If data in database column supplierid does not equal '' (blank, not NULL) then display the data from column supplierid...
If data in database column worksorderid does not equal '' (blank, not NULL) then display the data from column worksorderid...
Otherwise display nothing (would like BIRT to display "Not Applicable")
How do I go about writing an expression to do this? All the 3 columns referred to are in one Data Set in BIRT and all are in the same table in the SQL database. As I mentioned I'm a novoice so a step-by-step guide would be really helpful!
Thanks in advance!
Powered by FUDForum
. Page generated in 0.01623 seconds