Hi Alex, Create a new calculated field in your report. In the "Perform Calculation On" field of the editing dialog for that new calculated field, click the elipses "..." next to the drop down. This opens the expression builder. In the expression builder window, type your expression (your if/else statement). Click OK a couple of times to close dialogues. Drag the new calculated field onto your report layout as appropriate. That's about it.
Cheers, Kris > > Can you please elaborate further Kris.. tried it but couldn't go further > thanks ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282900 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
