Jump to content
Sign in to follow this  
Dan-A

Create temporary blank records

Recommended Posts

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

Share this post


Link to post
Share on other sites

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

...

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.