How can you Join a report field 2

[UCFSteve]

I need to join a report field that contains a Memo value.

The field has multiple values that I need to join and I dont want to display them in the Details section.

How can I join them similarly to a ForEach() where I can join all of the Memo values together?

 

[synapsevampire]

Supplying technical information is a great start:

Crystal version
Database/connectivity used
Example data
Expected output

Memo fields are limited in different versions of Crystal, so your post will likely net more posts until you take the time to state your environment and intent.

If you want to have all memo fields concatenated (using terms like join will probably confuse people), here's one approach:

Group Header Formula:
whileprintingrecords;
stringvar MyMemo:=""

Details formula:
whileprintingrecords;
stringvar MyMemo:=MyMemo & {table.memo}

Group Footer Formula: // used to display the data
whileprintingrecords;
stringvar MyMemo

Again, you may receive errors depending upon your version of Crystal, so please take the time to post technical information.

-k

 

[UCFSteve]

Crystal Version - 8.0
Database - ClearQuest MSSQL
Example Data - Field Name Attendence
Expected Output - I want to have a single value that I can insert into the report that contains all of the distinct names for the different attendees

 

[synapsevampire]

I gather that this didn't work since you're using an antique version of Crystal.

You're going to have to do somehting on the database as CR 8 doesn't allow for formulas to use Memo fields.

SQL Expressions might be used for each row if you only have a limited number of them, and then you can drop them all into a text object.

-k

 

[UCFSteve]

Thanks for you help, but no that did not work. I ended up combining the two records on the db side and bringing them in that way. Thanks anyways.

 

[synapsevampire]

Yeah, that's a sad limitation in CR 8.X

Once you upgrade you'll be able to work with fields > 254.

-k