[cyip@mmm.edu]

hi
i try to use formula to display some information vertically but i can't. Can anyone help?

this is the formula.
"Pledge Date: "&DateValue({Gf.Gf_Date})& " Amount: "
&{Gf.Gf_Amount}&" "& {@Balance}&" Fund: "&{Gf.Gf_Fund}

this is the return display
Pledge Date: 3/3/2004 Amount: $500.00 Balance: $0.00 Fund: 150 Golf Tournament

but i want the return like this :
Pledge Date: 3/3/2004
Amount: $500.00
Balance: $0.00
Fund: 150 Golf Tournament

how can i force the formula to display next line.

[digitalslacker]

if this is displaying on the web just doing something like
Pledge Date: 3/3/2004 & "<br/>"
will work
otherwise if this is a VB Applications do
Pledge Date: 3/3/2004 & vbCrLf
hope that helps

[DrewAllen]

There are several ways to approach this, and you happened to pick the hardest.

The easiest way is to create a text box and embed the data fields inside the text box wherever appropriate. You can easily add CR/LF in a text box.

The next easiest option is to create a separate formula for each line. Is there some reason that you did not take this approach?

The last option is to use the Chr() function to insert a carriage return Chr(13) and a linefeed Chr(10).

Since this was posted in the Crystal Forum, I'm assuming that the question was about Crystal rather than the web or a VB application.

Drew

[cyip@mmm.edu]

Drew
thanks for your help
the reason i donot use text box because it duplicated in detail section.
second option, i do not use separate formula because in my formula contain if statement.
the last option is working perfect, thanks for all your help


one more question if the gift is split gift

Pledge Date: 3/3/2004
Amount: $500.00
Balance: $0.00
Fund: 150 Golf Tournament; 101 Unrestricted fund; 102 library fund

how can i separate the fund by ;

Pledge Date: 3/3/2004
Amount: $500.00
Balance: $0.00
Fund: 150 Golf Tournament
101 Unrestricted fund
102 library fund

Quote:

Originally Posted by DrewAllen

There are several ways to approach this, and you happened to pick the hardest.

The easiest way is to create a text box and embed the data fields inside the text box wherever appropriate. You can easily add CR/LF in a text box.

The next easiest option is to create a separate formula for each line. Is there some reason that you did not take this approach?

The last option is to use the Chr() function to insert a carriage return Chr(13) and a linefeed Chr(10).

Since this was posted in the Crystal Forum, I'm assuming that the question was about Crystal rather than the web or a VB application.

Drew