Possible to append data from one table to another?

[projectpete]

Hello,

I am trying to run this pretty big report that I need some help with as the needs change every week. I am using crystal 8.5 reading from a ProISAM (ProIV) database.

I was wondering if it was possible to append data from separate db tables into one.

Example

DATA AS IS NOW

Ship Name Notes Inspection Type

ABC Co. turn left YI
DEF Co. turn right PI

DESIRED FORMAT

Ship Name

ABC Co., turn left, YI
DEF Co., turn righ, PI

 

[Turkbear]

Hi,
Your example does not indicate separate tables..
It appears you want to create 1 string with the 3 fields concatenated and comma separated..

If so, then create a formula:

@DisplayLine
Trim({Ship_name}) + "," + Trim({Notes}) + "," + Trim({Inspection_type})

Use this formula as your displayed detail instead of the 3 database fields..





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[projectpete]

beautiful thank you