>yes, thanks, Ed.
>
>If the result cursor has more employees in it than there are columns across the (landscape) page to fit on the report then I do the following:
>
>Say there are 10 columns of booked/charged data across the page. Then I go through the cursor and get each set of 10 records into a special cursor i keep just for the report.
> I report form this "batch" of 10 records then get the next 10 from the cursor.
>And so on till all the cursor recs have been printed.
>
>BTW, sorry but I need to leave work in 20 mins, so maybe carry this on tomorrow after that.
>
Sure, there still one issue left. If let's say Inv#1 has employees Bob and John, and next Inv.#2 has Derek and Paul; do you report them in 4 or 2 columns? In other words, each employee has fixed position in the report or you always squeeze them and print employee name in each report line? I suspect that the latter is the case, but still will appreciate if you confirm it. Could you do it now? If yes, then I will give full report querying outline in the next message and you could look at it when you get home.
Edward Pikman
Independent Consultant