Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 158
  • Last Modified:

Combine fields in a Data Report.

I have a data report that contains L_Name, F_Name, and M_Name and to conserve space I am trying to figure out how to combine these fields so 1 field will contain all three names as "Doe, John Q."  

I tried the method I would use in access, using the "=[L_Name]+....." in my field box method, but that didn't work.  Any other ideas?

Thanks in advance!
0
TinLemon
Asked:
TinLemon
1 Solution
 
JoaTexCommented:
Hi

Use Crystal report and add a Formula Field Like:
{L_Name}+","+{F_Name}+{M_Name}

Jo
0
 
vincentregentCommented:
try like this
for example, if you got 3 variables like LName, FName and MName, just combine them like this:

LName & FName & MName

If you want space between these you can do like this:

LName & vbTab & FName & vbTab & MName

'Or Like this:

LName & Space$(2) & FName & Space$(2)& MName

'if you want more space between them, change the two in
'a higher number

'It doesnt matter how you want to use it:

'a few examples:

'Putting it in a textbox:

Text1.Text = LName & Space$(2) & FName & Space$(2)& MName

'adding it to a list or datareport:

List1.additem LName & Space$(2) & FName & Space$(2)& MName

'Making a label:

Label1.Caption = LName & Space$(2) & FName & Space$(2)& MName

and so on


I hope this is usefull for you

Greetings,

Vincent







0
 
TinLemonAuthor Commented:
Vince, I think we are heading down the right path.  

The problem I've been having is still occuring.  I am using a DataEnvironment named ABC.  I am binding the data at design time through the properties menu of each Data Report text box.  When I place "LName & FName & MName" (or any of the other variations you presented to me) in the DataField property it says that "DataField ABC.LName & FName & MName cannot be found"

Thoughts?

0
 
BanathCommented:
A request has been made to refund and/or delete this question; if there are no objections within 72 hours, the request will be granted.

EXPERTS: Please leave your thoughts on the disposition of this question here.

Banath
EE Moderator
0
 
MindphaserCommented:
Points refunded and moved to PAQ

** Mindphaser - Community Support Moderator **
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now