Rather than being confined to the title section, the headings could be put as
data before the regular data. In advanced SQL it seems a string is placed first
in the WHERE with an OR or maybe it was done with a UNION. Just an idea.
RRR
david blocker 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
> >
