On your
report use the functions ICAP1 and ICAP2 to create variables
ICAP1
changes the fist letter to upper case:
SET VAR
vtxt = (ICAP1(‘john doe’)
Will result
in “John doe”
ICAP2
changes the fist letter of each word to upper case
SET VAR
vtxt = (ICAP2(‘john doe’)
Will result
in “John Doe”
I hope
this is what you are looking for…
Javier,
Javier Valencia, PE
President
Valencia
Technology Group, L.L.C.
14315 S. Twilight
Ln., Suite #14
Olathe, KS 66062-4571
(913)829-0888
(913)649-2904 FAX
-----Original
Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Jim
Van Dillen
Sent: Wednesday, February 12, 2003
6:26 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Formatting in
a report
|
I have been developing
forms to create court documents which extract data from a table. The
suggestions of members of this group have been most helpful.
I have the reports
basically running and producing usable documents at this time but I need to
apply some custom formatting to "Plaintiffs" name and
"Defendants'" name in the forms. I need to capitalize the
names in the memos. I know how to do this in a form but have been
unsuccessful in doing same in a report.
The Plaintiff's name
field in the report is an actual column in the associated table. The
Defendant's name field is a variable.
Part of the problem is
that the Format command speaks of making the "____" the same number
of characters as the text in the field. Obviously, with a number of
different Plaintiffs and a great many different Defendants, there is no way I
would know this length ahead of time.
I know this has to be
fairly simple but I have been unable to get this work in the report to this
point. Any help would be greatly appreciated.
Thanks,
JIM VAN DILLEN
Attorney at Law
1505 S. Big Bend Blvd.
St. Louis, MO. 63117
(314) 645-8008; Fax
(314) 645-8016
[EMAIL PROTECTED]
|
