[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Effective dated entries and totals etc. -Reply



One technique I have used for achieving a columnar printout is using
WRAP.  Create a string of the fields you wish to print stacked using a
special 'separation character' in between the entities.  Use the ON option
of WRAP to get your stacked results.

Lynn Francis
American Bankers Association

>>> Scott McCann <smccann@IONLINE.NET> 12/03/96 11:38pm >>>
Any suggestions/comments on the following would be appreciated.

I am writing a report that will include effective dated records.
Requirements I have questions on are
        1. How to easily keep totals against current effective date salary
values
        2. How to print a field (employee position) below another field
(name)

A simplified example of the report follows;

--- start report ---
Department:  Executive

Name            Effdt           Salary
Fred            10/20/96        $14,000
President       11/01/96        $18,000
                11/13/96        $22,000

Sam             10/20/96        $12,000
V.P.

Department Total $34,000
--- end report ---

Is there a way to accomplish item 1. via  PRINT BREAK or item 2. via
PRINT
(x,x,x) positional logic?
I have looked at the BREAK with AFTER and BEFORE to try and solve 1.
easily, but I have had to resort to if-then-else logic.
I have tried SKIPLINES for question 2. but this always causes the next
Effdt and Salary to skip down a line.