Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Column Formatting

Status
Not open for further replies.

psamedy

Technical User
Apr 22, 2002
60
US
Hello
Im trying to print a variable in a form letter in columnar format. The letter and the embedded variable exists in the detail section of a report.

This is what I was using:
WhileprintingRecords;
StringVar Item := {PPO_GROUP.DESCRIPTION}
StringVar Chain;
NumberVar ChCnt;

if ChCnt = 1
then (ChCnt:= 2; Chain:= Item)
else
if length(Chain) + Length(Item) > 254
then Chain := Chain else
Chain := chain+', '+Item

When I attempt to use the formatting script posted by Synapsevampire in a previous post I get an error stating that a number is required following the Chr(13). I'm not sure where I went wrong or if this will work for me. Please Help, Thanks

This is what i'm trying to use:

stringvar MyConcat := {PPO_GROUP.DESCRIPTION};
numbervar TheCounter := TheCounter+1;
if TheCounter/3 = int(TheCounter/3) then

MyConcat := {PPO_GROUP.DESCRIPTION}+replicatestring(" ",25-length({PPO_GROUP.DESCRIPTION})+chr(13))
else
MyConcat := {PPO_GROUP.DESCRIPTION}+replicatestring(" ",25-length({PPO_GROUP.DESCRIPTION}))
 
MyConcat := {PPO_GROUP.DESCRIPTION}+replicatestring(" ",25-length({PPO_GROUP.DESCRIPTION}))+chr(13)
else
MyConcat := {PPO_GROUP.DESCRIPTION}+replicatestring(" ",25-length({PPO_GROUP.DESCRIPTION}))

-k
 
Thanks
the formula returns no error, but the variable no longer accumulates the data I need for each letter.?.? It shows one record ({PPO_GROUP.DESCRIPTION})per letter.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top