Sounds like you need to create a calculated field in your .cfr file. That cfif statement would be the calculation. Then you'd just use that new calculated field in the layout of your report. Make sense?
Cheers, Kris On 7/4/07, alex poyaoan <[EMAIL PROTECTED]> wrote: > HI everybody.. > am new to report builder and just wondering where i will be placing the > conditional statements.. my case is for the location of zip code for address > meaning 1, 2, 3, 4 when it is 1 to the left of the city when 2 to the right , > 3 left of country 4 right of country.. I usually do this with this cfif > statement in a cfm page but with .cfr couldn't figure out where i'll be > placing it.. > > <cfif #zipcodepos# is ''> > #zipcode# #city#<br> > #coujntry# > > <cfelseif #zipcodepos# is 1> > #city# #zipcode# <br> > #country# > > <cfelseif #zipcodepos# is 2> > #city#<br> > #zipcode# #country > > <cfelse> > #city> > #country##zipcode# > > </cfif> > > the above works well with cfm where will i place it in a .cfr or coldfusion > report > any help please > thanks > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282890 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
