Hi all,

How can i "create" blank records to fill holes in printing??

I am ready to print a time card for a workweek, i need to print 7 days.

If however the employee has only worked 5 i want to create

(in the proper place --> date order) the blank record with the mention " OFF "

to say this was a day off.

I could create those blank records in the database but it seems

like a waste of space to have blanks in a workday file.

I thought of making one dummy record (with a date outside of any usable)

then find a way to include that record in the print range.

Any ideas?

Thanks

--Dan

creating temporary records is by far the easiest aproach if you use several layouts. Simply create them by script, then delete them again. Of course, auto-entered serial numbers will have to be generated using lookup max(selfjoin:serial#).

If you just need it for a single print layout, you can use container calcs and sliding to fill blanks in between.

Also, you can base your printout on employee# + week#. Then build relationships for every day of the week, placing apropriate fields on the layout:

emp#|monday::start time

emp#|monday::end time

emp#|monday::total hours

emp#|tuesday::start time

...

Is there a better way??

All i can think of for adding specific blank records

is to loop thru a date range (7 days) for a given employee

try to match every day of the week, if no match create

that day.

This sound like it will take a lot of time to process.

Is there a better way??

Thanks

--Dan

You could also make a labels layout with a very large header, to push the labels down the page.

Hi Vaughan,

I have never tried labels with FM.

Can you explain a little more.

What do you mean by push the labels down?

Right now my layout is a list with:

Header for employee info and week info

Body for each workday (from workday file)

(this is where only 5 records show if 5 work days, i need to always show 7)

Footer for weekly totals

Thanks for the help

--Dan

Ugly but functional ...

no need for blank records in this attachment

workweek.zip