Skip to main content
April 15, 2008
Question

combining fields

  • April 15, 2008
  • 2 replies
  • 707 views
Is it possible to combine fields? When I do it, I get errors when outputting the cfreport.

For example, firstname and lastname are two separate fields. I want them within one so that the spacing is right. When I put both on the template in Report Builder, I get errors when it is run in ColdFusion. I'm new to Report Builder, but I can certainly see the advantages already.
This topic has been closed for replies.

2 replies

April 15, 2008
Thank you! You are wonderful. I must not have written it correctly when I tried it because it worked with your code!! Again, thank you so much.
Inspiring
April 15, 2008
Try something like : trim(query.fname_e) & " " & trim(query.lname_e)

Just as you would in CF.

Claude