>- see footer for list info -< Thanks for your reply... I don't think you can put multi-lines in the Expression Builder...
I don't really know CFR that well, just been hunting around and found that we can add a Report Function so we've coded it like a normal function and tried to call it from the Expression Builder... still no joy. Does anyone have experience with testing a field for multiple values and setting a label to some value depending on the 'value'. Cheers 2008/8/14 <[EMAIL PROTECTED]> > >- 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 <http://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 <http://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 -<
