Textbox Wrap but Keep some Fields Together when Wrapping

[stacyow]

I am using CR for VS2010 with a winforms app and SQL 2008 R2.

I have a two column report that has a textbox with multiple fields (Con1Name Con1HmPhone Con1WkPhone Con2Name Con2HmPhone Con2WkPhone) in it in one section of the report.

The problem is that when all of these fields are full it needs to wrap down to another line, however I want control of where it wraps.  So if it needs to wrap I want it to keep all of Con2's together on the second line.

So it would look like this...

Stacy 651-555-1234 651-222-1111 momo@gmail.com

Emily 651-555-5678 651-333-2222 kid@gmail.com

instead of this...

Stacy 651-555-1234 651-222-1111 momo@gmail.com Emily 651-555-5678 651-333-2222

kid@gmail.com

Does Crystal Reports allow this kind of control in a textbox?

Thanks,

Stacy

[DellSC · Accepted solution]

The only way I know of to control this would be to ALWAYS have the conn2 fields on a new line, regardless of whether it needs to wrap.

Are you concatenating the fields together in a formula or did you just drag them all into a text box?  If you're using a formula, then you would do something like this in it to wrap the text:

<conn1 fields> + CHR(13) + CHR(10) + <conn2 fields>

If you just dragged them all into a text box, then you would put your cursor at the beginning of the conn2 fields and press the "Enter" key.

-Dell