Link to home
Start Free TrialLog in
Avatar of CochiseCounty
CochiseCountyFlag for United States of America

asked on

Crystal Report format problem

In the details section of my Crystal Report, I arrange the fields in horizontal line, not column, it looks like this
Field1
Field2
Field3
Field4
And I enable the 'Can Grow' property, the problem is, for example, Field2 grows to 3 lines, then the Field3 jam together with text in Field2, how do I fix that? thanks for help
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
You can also concatenate all 4 fields by adding a Formula Field.

Add a new formula field.  In the formula editor that pops up, edit the formula.  I've found using Basic Syntax easier than Crystal Syntax. The formula would look something like this:
formula = {tblTableName;1.Field1} & " " & {tblTableName;1.Field2} & " " & etc...