[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.
- Subject: Effective dated entries and totals etc.
- From: Scott McCann <smccann@IONLINE.NET>
- Date: Tue, 3 Dec 1996 23:38:09 -0500
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.