Save Multiple Finds to a single PDF

[mcdirt]

Hi, any help here greatly appreciated ...

 

I have a simple table that has the fields: Job Number(Number), Start Week(Number), Job Interval(Number), Job Description(Text).

Each job can start on any week (up to 52) and can have an interval of any weeks (up to 52).

 

So a job with Start Week =1 and Job Interval = 1 will happen every week and a job with Start Week = 8 and Job Interval = 12 will happen on weeks 8, 20, 28, 36 etc.

 

I am trying to write a Script that will print out a year's jobs to a PDF file for printing later. I have broken it down into 2 Scripts as shown in the screenshots.

It's not working so if anyone could point me in the right direction, then thanks heaps.

 

rgds mcdirt

 

 

[bruceR]

You are saving to PDF using the "append" option.

 

To do this, there has to be a file to append to!

 

The first save to PDF has to create the PDF file. Then for all other records in your loop, you can use the append option.

[mcdirt]

Hi Bruce & thanks. It seems to work though - this new version of the 2nd Script Finds the Records that have a Start Week of 1, 2, 3, 4, etc and Prints them to a single PDF using Append.

 

The hard part for me is trying to figure out how to write into the Script for it also to Find records where [(Start Week + $$Week x Job Interval) /$$Week = 1].

Any help with getting that to work greatly appreciated.

 

 

rgds mcdirt

[mcdirt]

Talking to myself again - this seems to work ...

 

Add another field to the Table with Calculated Field - (Start Week = $$Week) or ( Mod ($$Week - Start Week; Job Interval ) = 0 ) - do not store calculations

This should be a 1 when the jobs are due, use Previous 2 Scripts, looking for a 1 in the Calculated Field - prints out 52 pages seem right.

 

Happy but if there is a better way of doing it, pls let me know.

 

rgds mcdirt

[comment]

if there is a better way of doing it, pls let me know.

 

A better description of "it" - i.e. what is the final goal of this exercise - would be helpful.