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

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

 Page 1 of 1 [ 5 post ]

Relevant Pages