A period in the 70 spot, huh? Pretty bright! Now why couldn't I come up
with that? I too would like to get my old DOS headings capabilities back.
Ike
At 12:36 PM 10/5/01 -0400, you wrote:
>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
> >
