« December 17, 2007 | Main | December 19, 2007 »

December 18, 2007 Archives

December 18, 2007

If 'Have Cold' then 'Doctor' else 'Misery'

Last week, at least I think it was last week, it feels like I have been writing in a 'cold' 'miserable' fog lately. I finally visited the doctor today, 'walking pneumonia' was the prognosis - it explains a lot. I have been feeling completely worn out these last weeks with a cough and what can only be described as a 'snotty' nose ... apologies for the conjured image.
Anyhoo, Im now drugged to the eyeballs in the great American tradition. Im not allowed to be my 'reserved English self' here, just 'getting on with it' - when I used to walk into a doctor's surgery in the UK and was asked 'so how are you?' I always found myself saying 'yeah, Im good' - 'then why are you here to see me' was the doctors quippy retort. Very drole! I have been converted, when I go in now, which is still pretty rarely - I ensure a good throaty cough is my answer to any question ... nice.


Moving on, or back to last weeks entry on Watermarking II. Buried away in that post was mention of a little known feature that I thought was worth its own entry. Those of you that know Excel will know that it has an 'inline' if statement, it's very useful - well its come to BIP. It's a simple command that takes the format:


xdoxslt:ifelse(boolean expression ,true result, false result)


in use we get something like


xdoxslt:ifelse(.//WM_FLAG='C?,'Canceled','Approved')


So we can return strings, numbers or even element values from the if statement. You can even nest 'if' statements within the command e.g.


xdoxslt:ifelse(.//WM_FLAG='C?,'Canceled',xdoxslt:ifelse(.//WM_FLAG='A?,'Approved','Pending'))


I have not seen how deep I could nest but it ought to be as deep as you wish. Hopefully it should prove useful to you, its available from release 5.6.3. onwards.

About December 2007

This page contains all entries posted to Oracle BI Publisher Blog in December 2007. They are listed from oldest to newest.

December 17, 2007 is the previous archive.

December 19, 2007 is the next archive.

Many more can be found on the main index page or by looking through the archives.

Powered by
Movable Type and Oracle