Joining Fields

[BoniR]

Hello all...
I am looking to display all values for a field in a report done in Crystal 9 with out creating an array...
Anyone have any ideas?
The field will be a formula that concatenates the first and last name.
Thanks in advance!
Boni


Boni J. Rychener
Hammerman Associates, Inc.
Crystal Training and Crystal Material
On-site and public classes
Low-cost telephone/email support
FREE independent Crystal newsletter

http://www.hammerman.com

800-783-2269

 

[synapsevampire]

Hi Boni, and say hello from Kai to Howard for me.

In general it is best to use example data and expected output rather than a description as it leaves too much to the imagination.

So displaying all values for a field might mean that you just concatenate a first and last name in a formula, or it might mean that you want a single concatenated field for all fields.

It's simple to concatenate fields, and you might even do all of this on the database side using a SQL Expression or SQL, but we need technical information, such as:

Database/connectivity used
Example data
Expected output (based on the example data)

Concatenating fields is as simple as creating a formula and using:

{table.first}+" "+{table.last}

To concatenate every value into a formula, one would use the following in the details:

whileprintingrecords;
Stringvar AllNames:= AllNames+
{table.first}+" "+{table.last}+" "

Then after the details display with:

whileprintingrecords;
Stringvar left(AllNames,len(AllNames)-1)

If the above doesn't suit the requirements, please post them.

-k

 

[BoniR]

You are AWESOME!!!!
I have been battling with this for a few weeks...not straight though!
I will definately say hi to Howard for you!
Have a great weekend!!!
Boni


Boni J. Rychener
Hammerman Associates, Inc.
Crystal Training and Crystal Material
On-site and public classes
Low-cost telephone/email support
FREE independent Crystal newsletter

http://www.hammerman.com

800-783-2269