[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.



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.