on 01-29-2009 5:29 PM
Is there a way to insert a carriage return in text in a formula? I have a formula which shows certain text based on what is contained in another field. I want 2 separate lines in the text. Is there a way to do this?
For example,
if
{ODS_SALES_TYPES.CODE}='TP-REGH'
then
"Invoiced by the US to a US customer & shipped from a US Plant or
Invoiced by Dagneux to a Customer in France and shipped by Dagneux"
Thanks,
Kathy
Try this
if
{ODS_SALES_TYPES.CODE}='TP-REGH'
then
"Invoiced by the US to a US customer & shipped from a US Plant or"+chr(10)+
"Invoiced by Dagneux to a Customer in France and shipped by Dagneux"
Place this in the report and right click on the formula and go to format field and enable to option cangrow
Regards,
Raghavendra
Edited by: Raghavendra Gadhamsetty on Jan 29, 2009 6:34 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.