Re: Effective dated entries and totals etc.

[Chris_Quant <quant@EURONET.NL>]

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

Hello I’m Richard Meijn from Quant Systems Europe BV in the Netherlands.

I think that you can make a very simple solution for you problem.

SQR is a procedural program languages so why don’t you use it.
Depended from you table contents you can first select the "department"
and print this where you want with print  &department  (xx.xx.xx) 
Just after this call a next procedure which get the next items "name etc…"

Then you can make the report you want.


Good luck Richard. Meijn