>- see footer for list info -< I don't know CFReports but could you not do it as separate IF statements?
The Robert Gordon University is the best modern university in the UK (The Times Good University Guide 2009) The Robert Gordon University, a Scottish charity registered under charity number SCO 13781. This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nick Middleweek Sent: 14 August 2008 14:52 To: Coldfusion Development Subject: [CF-Dev] help with Expression Builder in CFReports >- see footer for list info -< Hello, We've got this expression in CFR which is fine... IIf((InvoiceWOPO.mediatypeID is 59), DE("Pack Item Title"), DE("Media Owner")) ...but we want to expand on it so we can add another clause to it... * 89 = Literature... I was thinking we could do an excel style nested If... like this but it doesn't appear to be working: IIf((InvoiceWOPO.mediatypeID is 59), DE("Pack Item Title"), IIf((InvoiceWOPO.mediatypeID is 89), DE("Literature"), DE("Media Owner"))) Does anyone know if we can do what we're after? Thanks in adance!... Nick _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
