Karen,

        What if you put each type of data into a different
column based on the type of formatting you want:

ColID INTEGER = RowID  for a consecutively numbered row
ColA NOTE = Heading Type A
CoB NOTE = Heading Type B
ColC TEXT = Data of one type such as Underlined Procedure
Names
ColD TEXT = Data of a different type such as bulleted
services
ColE DATE = Dates of scheduled service
ColF NOTE = Chatty informative message

        Now in your report use headings which can be created
based on breakpoints which you can set for each column.

        You can format each "column" differently so that
ColA has large font, underlined with italics.  ColB could
all be of a different color.

        Each RowID will define a row to be printed.

        You could even put the same report in parallel
columns by creating an additional set of fields for the
second group:

ColA2 NOTE = Heading Col 2 Type A
ColB2 NOTE = Heading Col 2 Type B
ColC2 TEXT = Data of one type such as Underlined Procedure
Names
ColD2 TEXT = Data of a different type such as bulleted
services
ColE2 DATE = Dates of scheduled service.

        When you put data into this table, only fill one
field on each row.

1  In other words, in row one, put the headingA in ColA (and
col A2).
2  In row two, put headingB in ColB (and col B2).
In row three - six put data in: [breakpoint on ColC? ]
3        ColC     Diagnostic Preview             ColC2
Routine Exam
4        ColD        take medical history         Col D2
get weight
5        ColD        obtain completed forms   Col D2 [leave
blank]

        You could create variables based on the column
values such as
varColD TEXT = ( (CHAR(149)) & ColD)

CHAR(149) is a bullet
CHAR(196) is a hollow bullet
CHAR(182) is the paragraph symbol

        By placing the columns in headers and footers, or by
populating the detail lines in consecutive order as you wish
your data to appear, I think you will come close to what you
are trying to imagine.

        Randy Peterson

----- Original Message -----
From: "tellef" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[EMAIL PROTECTED]>
Sent: Thursday, February 13, 2003 1:02 PM
Subject: [RBASE-L] - My Complicated report example


>
> Here's an example of the type of report that I am
> trying to reproduce in Windows.  In Dos it is a series
> of about 8 different reports.  I'm sure you can see
> how difficult this would be to do in a temp table!
> Go ahead -- tell me how!  PAGEMODE might work but I
> am unable to get it to keep formatting variables (I
> need underlining and boldfacing).
>
> Karen
>
> ---EXAMPLE (and some of this needs to be underlined,
> some of it boldfaced):
>
> There's a paragraph here, maybe just one sentence.
>
> Now another paragraph here.  But this one will be
> followed by a bulleted list of things:
>
> 1.  Here is point number one
>
> 2.  Here is point number two, but depending on
>     conditions might have further points below:
>
>     a.  Here is subpoint a
>
>     b.  Here is subpoint b, which has a table
>         of data from another table yet:
>
>         John Smith     12/1/99    Needs a test
>         Mary Beth      11/30/01   Needs an xray
>           Wellington              and an ultrasound
>
> Now it goes back to more paragraphs.  But there will
> definitely be more subpoints and tables from different
> tables below (tables with different column counts and
> widths).
>
>
>
>
>
>
>

Reply via email to