report retreat event to turn on 2nd page warning by group

J

JohnK2006

I have a workorder report that is usually 1 page long. However, occassionally
there will be a second page to a particular workorder when there are more
items (rows) in the detail section that can fit on one page. I would like to
make a warning flag visible on the first page of the workorder (page footer)
whenever the workorder is multi-page. I am printing multiple workorders at a
time grouping on workorder ID with the "keep together" property turned on.
Whenever the detail section is too long to fit on one page, I want to make
the "warning" field property set to visible. I have created a macro (2page)
to do this, and tried to place it in the detail section "On Retreat" event,
but it does not work. Obviously I also need to turn this visible property off
again for the next workorder if it is only one page. I also wrote a macro
(off) to do this, and tried to put it in the "on format" event for the detail
section. I turned on the macro step function and I can see the "off" macro
running but the "2page" macro never runs, even when the report goes to two
pages. What am I doing wrong? Please help. I also tried to use the "page N of
M" function but it shows the total pages from all the workorders being
printed instead of just the pages of each workorder.

Thanks,
John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top