Report formatting

Report formatting

Post by Terje Larse » Wed, 03 Feb 1999 04:00:00





> I'm using Progress v8.2a to develop a system and I'm producing a relatively
> straightforward report. My question is how do I do things like bold on/off,
> underlining, font sizing etc. from within the report itself.

> This is how I'm producing the report:
>   - set OUTPUT to a .tmp file
>   - PUT statements to write out to this .tmp file
>   - OUTPUT CLOSE
>   - run _osprint.p to send .tmp file to hp laserjet printer
>     (the _osprint.p module comes with Progress itself)

> As I said, very basic, very simple. But _osprint.p does not give you any
> control over printing bold headings or underlining a field and so on. It lets
> you specify one font for the report and that's it. End result looks very dull.

> I have already tried PUT CONTROL followed by escape sequences, for example:
>    PUT CONTROL "/027(s3B". /* bold on */
>    PUT "I Want This Heading To Be Bold" AT 1.
>    Put CONTROL "/027(s0B". /* bold off */

> It doesn't work.

Try PUT CONTROL "~033(s3B".
Progress 4GL does not understand hex - use octal instead.
The / (slash) character cannot be used as an escape character,
either \ (backslash - unix only) or ~ (tilde) must be used.

Anyway, I don't know if it works with _osprint.p...

--
Terje Larsen


 
 
 

Report formatting

Post by Niels Diepevee » Fri, 05 Feb 1999 04:00:00



> As I said, very basic, very simple. But _osprint.p does not give you any
> control over printing bold headings or underlining a field and so on. It lets
> you specify one font for the report and that's it. End result looks very dull.

> I have already tried PUT CONTROL followed by escape sequences, for example:
>    PUT CONTROL "/027(s3B". /* bold on */
>    PUT "I Want This Heading To Be Bold" AT 1.
>    Put CONTROL "/027(s0B". /* bold off */

> It doesn't work.

Reason #1: I assume "/027" is intended to be an escape character.
    This should be written as "~033". (octal)
Reason #2:
    You can't do this sort of thing with _osprint. If the printer
you     want is shared on a network you can use
      OUTPUT TO "\\server\printer".
    If it's a local printer you could put the data in a file and use
      OS-COMMAND SILENT "copy report.tmp lpt1".
    or use some other program to send it to the printer as RAW data.

----
Niels Diepeveen
Endea automatisering

 
 
 

1. Manipulated data from report format

Hi,
I have a text file with data in report format.  my task is
to bring this format into SQL Server.
I used to do this in Visual FoxPro, but the current
environment don't have FoxPro.
Does anyone have experience of pulling this kind of dat
into SQL Server.

0000162 PLATINUM AT,TEST33        .03010 C  0904
 CR LINE -                 100         AVL CRED
0001046 SOMMERS,RUTH              .03010    1104
 CR LINE -               5,000         AVL CRED
0001053 DIMA,ROMANO               .03010 ZX 1104
 CR LINE -               6,500         AVL CRED

Your help is greatly appreciated,
Culam

2. HELP--Need Search routine

3. Question on ListView Control - Report Format

4. DB2 Authority Report

5. SQL*Plus report formatting

6. Parameters

7. Oracle SQL*PLUs-Report format question

8. Naming Stds for SQL Server Objects

9. SQL*Plus report format layout

10. Pro*C Report formatting

11. SQL*Plus report format layout

12. Report Formatting with ASCII codes