Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: next line Post Reply Post New Topic
Author Message
Brian Paff
Newbie
Newbie


Joined: 26 Oct 2007
Location: United States
Online Status: Offline
Posts: 3
Quote Brian Paff Replybullet Topic: next line
    Posted: 26 Oct 2007 at 10:42am

This is the first part of the estimate response form report header that has our company info and also our phone number. In the original report it put the phone number right after the zip with no space. I found the place in crystal that pertains to this and added the +” “ after their code and it added a space. I need to know how to make it move the phone number down a line.

 

HYPNEUMAT, INC.

5900 WEST FRANKLIN DRIVE

FRANKLIN WI 53132-9178 414-423-7400 FAX:7414

 

StringVar sAdd0Value;

sAdd0Value:="";

If Not IsNull({Rpt_EstimateResponseFormSp;1.Addr0}) Then

    sAdd0Value:=sAdd0Value+{Rpt_EstimateResponseFormSp;1.Addr0}+" "

Else

    sAdd0Value:=sAdd0Value;

If Not IsNUll({Rpt_EstimateResponseFormSp;1.ParmsPhone}) Then

    sAdd0Value:=sAdd0Value+{Rpt_EstimateResponseFormSp;1.ParmsPhone}

Else

    sAdd0Value:=sAdd0Value;

 

IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 26 Oct 2007 at 1:13pm
Add the linefeed characters and make sure the field is set to Can Grow.
ChrW(13) + ChrW(10)
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
Brian Paff
Newbie
Newbie


Joined: 26 Oct 2007
Location: United States
Online Status: Offline
Posts: 3
Quote Brian Paff Replybullet Posted: 29 Oct 2007 at 1:30pm
Please be more specific, I am a first time user of Crystal. Can you show me what I have to add and where I have to add it in the code? Thanks.
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 29 Oct 2007 at 1:50pm

Put the codes in front of the code that adds the phone number like so:


If Not IsNUll({Rpt_EstimateResponseFormSp;1.ParmsPhone}) Then

    sAdd0Value:=sAdd0Value+ CHRW(13) + CHRW(10) +{Rpt_EstimateResponseFormSp;1.ParmsPhone}

Else
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
Brian Paff
Newbie
Newbie


Joined: 26 Oct 2007
Location: United States
Online Status: Offline
Posts: 3
Quote Brian Paff Replybullet Posted: 29 Oct 2007 at 2:14pm

That worked great, thank you very much.

IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.000 seconds.