Combine text and data?

Hi,

Is there a way to concatenate text and data from a field?

For example...the query returns "Steve Smith" in a field "CustName".  I want to display "Customer Name: Steve Smith"...but I would like to do that in a single control (label, record box, whatever).

I've tried a number of variations such as

"Customer Name: " & [CustName]

in the Field and DataFormat property of the record box control...with no luck.  Is this possible?

Hello,

You can achieve our requirement without any problem using our DynamicPDF ReportWriter for .NET  product. Below is the syntax to add the text and field data using a sinlge report element.

Customer ID: #CustomerID#

Thanks,
ceTe Software Support Team.

Hi,

Customer ID: #CustomerID#

works with the record area and formatted record area objects.  But it does not work with the record box object.  Should it?

Thanks,

Ray

Hello Ray,

Yes the same Text which you have will not work for both RecordArea and RecordBox. RecordBox has a Field property where you have to give the database field name to display without adding any text. It can take functions with multiple database fields.

You can refer to the help documentation on our website which shows the details for RecordBox and RecordArea.

Thanks,
ceTe Software Support Team.