How do i put results in different lines in crystal reports

[Former Member]

I have this in my formula

else

"Madame,Monsieur" + " " + {GfCnBio.GfCnBio_Last_Name}

i would like to put

Madame, Lastname

Monsieu, Lastname

on 2 different lines.

please help

thanks you

[Former Member]

I tried this and it worked

"Monsieur " + "," + chrw(10) + "Madame " + {GfCnSpSpBio.GfCnSpSpBio_Last_Name} + ","

else

"Madame" + " ," + chrw(10) + "Monsieur" + " ,"

thank you very much for you assistance

[Former Member]

Put what's below into a Text Object with a carriage return (Enter key) after the first line:

Madame, {GfCnBio.GfCnBio_Last_Name} <Carriage Return here>

Monsieur, {GfCnBio.GfCnBio_Last_Name}

OR do the same with a formula using a CHR(10) after the first line:

"Madame," + " " + {GfCnBio.GfCnBio_Last_Name} < put CHR(10) here >

"Monsieur," + " " + {GfCnBio.GfCnBio_Last_Name

Edited by: James Terry on Sep 9, 2008 6:12 PM

Edited by: James Terry on Sep 9, 2008 6:14 PM

[Former Member]

Try this

"Madame," + " " + {GfCnBio.GfCnBio_Last_Name}chrw(10)"Monsieur," + " " + {GfCnBio.GfCnBio_Last_Name}

and extend the height of the object to see the next line

Regards,

Raghavendra

[Former Member]

Try this...

"Madame," + " " + {GfCnBio.GfCnBio_Last_Name}

"Monsieur," + " " + {GfCnBio.GfCnBio_Last_Name}

I believe that is what you were looking for. If no then please let us know.

Regards

Ankeet

Edited by: Ankeet Wagh on Sep 9, 2008 5:45 PM