I often use the TITLE option of the CHOOSE command to create column headings
for the data appearing in the CHOOSE box below if the data is multiple
columns from a table. However, several features of the the TITLE line make
this a challenge:
1. The TITLE line is limited to 70 characters
2. The placement of the text in the TITLE line is ALWAYS automatically
centered by R:Base
3. The actual width of the text as it appears in the Title line will depend
on the characters in the text, since R:Base uses proportional fonts
What I WANT in the display would look something like this:
ORDER NUMBER REVISION CUSTOMER
0010721 02/01/2001 NIDEC POWER
0010722 02/01/2001 ACT MANUF.
0010723 02/01/2001 ABC MANUF.
0010724 02/01/2001 IRONBRIDGE
Because of the above limitations, the best I've been able to come up with is
something like this:
1. Create the TITLE first, in a variable; to use the max number of
characters, since R:Base ignores trailing spaces, create a variable with a
period in position 70:
SET VAR vTitle = (SPUT('+
ORDER NUMBER REVISION CUSTOMER','.',70))
2. Experiment with the widths of the first two columns in the CHOOSE
command to get the best lining up I can:
The 3 columns in the example are:
ORDERNUM TEXT 7
REVISION_DATE DATE
CUSTOMER TEXT 24
CHOOSE vOrder FROM #VALUES FOR (LJS(OrderNum,14) +
LJS(CTXT(Revision_Date),12) + Customer), OrderNum +
FROM Status +
WHERE Revision_Date BETWEEN .vStart and .vEnd +
ORDER BY OrderNum +
AT 3 5 +
TITLE .vTitle +
CAPTION .vTask +
LINES .vLines +
FORMATTED
The result is not exactly what I want:
ORDER NUMBER REVISION CUSTOMER
0010721 02/01/2001 NIDEC POWER
0010722 02/01/2001 ACT MANUF.
0010723 02/01/2001 ABC MANUF.
0010724 02/01/2001 IRONBRIDGE
Has anyone found a way to do this with less trial and error and cleaner,
more predictable results?
David Blocker
----- Original Message -----
From: "Lawrence Lustig" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 02, 2001 9:28 PM
Subject: Re: Possibility to Increment by only 1?
> > I intended to increment by 1 the check numbers in the Report Footer of
the
> > one page report. When I set up a variable defined to increment the
check
> > number by 1 the check number is incremented by the number of items in
the
> > detail not by the number of checks printed.
> >
> > Am I asking too much of a report?
>
> Not at all. You simply need to use the Variable | Change Section option
on
> the Reports menu to move your variable from the Detail section to the
> appropriate section (from your description the Report Footer, although the
> Page Footer or Break Footer might be more appropriate if you are printing
> more than one check in the report).
> --
> Larry
>
>
>
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>
