Becky, I had this same problem. The answer was to put the concatenation inside the field. What I mean is just put the field on the report. Then double-click it to bring up the expression editor (I think that's what it's called). In there you can put; Trim(query.AreaFull) & " Area" <!--- notice the leading space --->
Then when report builder renders the report, the whole field comes out right. Hope that helps. Chris On 10/18/07, Becky McDermott <[EMAIL PROTECTED]> wrote: > > I have been playing around with the MX7 Report Builder and I have a few > questions. I have a dynamic field which is defined by the following: > > query.AreaFull & "Area" > > When the report is rendered, there is a big space between the two > concatenated strings. For example, the text gets rendered as "Tucson > Area" instead of "Tuscon Area". If I make the field's width smaller, then > it can be cut-off. Any suggestions how I can make this appear correctly? > > The second question I have is how can I shade alternating rows in the > report? > > Finally, are there any good books or documentation out there regarding the > report builder? Are people actually using it or using 3rd party tools for > reports? > > Thank You, > > Becky > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291480 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
