Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Return multiple lines from formula fields 1

Status
Not open for further replies.

HaveTrouble

Programmer
Jan 10, 2005
63
US
I have a formula field on crystal report and would like it to print:

line 1
line 2
line 3

instead of:

line 1 line 2 line 3. How can I do that ?
 
You probably need to share the contents of the formula. If your formula is a string, you should be able to add returns by inserting chr(13) into your formula, as in:

"The turtle"+chr(13)"crossed the road"+chr(13)+"to get to"+chr(13)+"the Shell station."

This would return:

The turtle
crossed the road
to get to
the Shell station.

You would then right click on the formula->format field->common->and check "Can Grow".

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top