[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
- Subject: Effective dated entries and totals etc. -Reply
- From: Lynn Francis <lfrancis@ABA.COM>
- Date: Fri, 13 Dec 1996 08:16:46 -0500
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.