What is chr$(13) + chr$(10) 
Author Message
 What is chr$(13) + chr$(10)

Very similar in CR5:

"this is the first line" + CHR(13) + CHR(10) + "this is the second line"

--
Les Schmalzbach
(remove nospam- to reply).

yung_chan (Joshua Chan) wrote in article

Quote:
> I have create a report which have a mutiline formula field
> but how can I make a newline in the formula

> Thanks

> ------------
> Joshua Chan



Mon, 28 Feb 2000 03:00:00 GMT  
 What is chr$(13) + chr$(10)

Using chr(13) is actually enough to do this.  For example, in your formula
do this:

{table.field1} + chr(13) + {table.field2}

If your fields are numbers you can do this:

ToText({table.field1}) + chr(13) + ToText({table.field2})

Or if you have Crystal Report 5.0 you can do this:

ToText({table.field1},2) + chr(13) + ToText({table.field2},0)

The numbers after the fields in the ToText control how many decimal places
will display.

By the way, if you are just talking about being able to put multiple
commands in a formula field, use a semi-colon (;) at the end of each line.

yung_chan (Joshua Chan) > wrote in article

Quote:
>I have create a report which have a mutiline formula field
>but how can I make a newline in the formula

>Thanks

>------------
>Joshua Chan



Mon, 28 Feb 2000 03:00:00 GMT  
 What is chr$(13) + chr$(10)

I have create a report which have a mutiline formula field
but how can I make a newline in the formula

Thanks

------------
Joshua Chan



Mon, 28 Feb 2000 03:00:00 GMT  
 What is chr$(13) + chr$(10)

I have write a formula like this, but it does not work

StringVar Temp := {table.field1};
if temp <> "" then temp := temp + chr(13) + {table.field2}
else
        temp := {table.field2};
Temp

But the Program cannot regonise chr(13)
Thanks

On Thu, 11 Sep 1997 06:32:44 -0400, "David Finkelstein"

Quote:

>Using chr(13) is actually enough to do this.  For example, in your formula
>do this:

>{table.field1} + chr(13) + {table.field2}

>If your fields are numbers you can do this:

>ToText({table.field1}) + chr(13) + ToText({table.field2})

>Or if you have Crystal Report 5.0 you can do this:

>ToText({table.field1},2) + chr(13) + ToText({table.field2},0)

>The numbers after the fields in the ToText control how many decimal places
>will display.

>By the way, if you are just talking about being able to put multiple
>commands in a formula field, use a semi-colon (;) at the end of each line.

>yung_chan (Joshua Chan) > wrote in article

>>I have create a report which have a mutiline formula field
>>but how can I make a newline in the formula

>>Thanks

>>------------
>>Joshua Chan

Thanks

------------
Joshua Chan



Tue, 29 Feb 2000 03:00:00 GMT  
 What is chr$(13) + chr$(10)

 Try making it chr$(13) instead of chr(13)

yung_chan (Joshua Chan) > wrote in article

Quote:
>I have write a formula like this, but it does not work

>StringVar Temp := {table.field1};
>if temp <> "" then temp := temp + chr(13) + {table.field2}
>else
> temp := {table.field2};
>Temp

>But the Program cannot regonise chr(13)
>Thanks

>On Thu, 11 Sep 1997 06:32:44 -0400, "David Finkelstein"

>>Using chr(13) is actually enough to do this.  For example, in your formula
>>do this:

>>{table.field1} + chr(13) + {table.field2}

>>If your fields are numbers you can do this:

>>ToText({table.field1}) + chr(13) + ToText({table.field2})

>>Or if you have Crystal Report 5.0 you can do this:

>>ToText({table.field1},2) + chr(13) + ToText({table.field2},0)

>>The numbers after the fields in the ToText control how many decimal places
>>will display.

>>By the way, if you are just talking about being able to put multiple
>>commands in a formula field, use a semi-colon (;) at the end of each line.

>>yung_chan (Joshua Chan) > wrote in article

>>>I have create a report which have a mutiline formula field
>>>but how can I make a newline in the formula



Sat, 04 Mar 2000 03:00:00 GMT  
 
 [ 5 post ] 

 Relevant Pages 

1. chr(10) and chr(13) in memofield gives |

2. Chr(10) & Chr(13)

3. Chr(10) and Chr(13) doesn't work

4. INPUT OR READ TO STRIP CHR(10) AND CHR(13)

5. vbCRLF = chr(13) + chr(10)

6. is carriage return chr(13) or chr(32)

7. No Sentences in Title?! / No Chr(10) or Chr(13) in titles!!!

8. Global Const CR = chr$(13) + chr$(10) uh oh!?

9. chr(13) & chr(10) in a text box

10. Enter Parameter value CHR(13)

11. Appending chr(13) to a memo field?

12. what's the difference...(chr(13)) and vbCr

 

 
Powered by phpBB® Forum Software