Reports

[Duane]

I have a report that shows all the tools assigned to a Work Area. The
report groups the records by location within that Work Area(forces a new
page after each group). In the Report Footer I have created a signature
page. I have the Page Header, the Tool Manager and Work Area Supervisor
fields, and a spot for their signatures. I also show the Page of Pages text
box in the Page Footer of the last page only. Typically, you would show the
page of pages on all pages but here is the problem.

If there were only one page or one location within all the work to print
whenever and inventory was updated (and they are updated all the time), then
this would be great. Unfortunately some of the work areas have several
locations and dozens of pages. Some of the changes would affect the page
count of the report. In lieu of printing many unnecessary pages of a report
I have a second report that allows the user to print only the location that
has been affected.

The issue I am facing is my signature page with the correct page count! I
have thought about just instructing the end user to open the complete report
and navigate to the appropriate location and print those pages, and then
navigate to the last page and print a new signature page. This is not very
efficient.

What would be ideal is to allow the user to open up the Location report and
print the affected location(s). On the OnClose Event of the location
report, ask the user if they wish to print a new signature page. If the
answer yes, then open the complete report in hidden view and print the
signature page (Last Page) - which includes the total number of pages.

The page thingy is important to the powers to be. Is there a way to open a
report in this manner and navigate the report with code to the last page and
print it automatically, or allow the user to print it? I know I can open
the complete report from the OnClose event of the location report, but I
would like to go to the last page. Maybe I would simply have to open the
report with a msgbox informing the user to go to the last page and print it.

Any ideas would be greatly appreciated.

Thank you in advance.

 

[Duane Hookom]

If you "What would be ideal is to allow the user to open up the Location
report and
print the affected location(s)" then why not just filter the report to the
"affected location(s)"?

 

[Duane]

How do I get the correct page numbers to show up on the signature page? I
do open up the Location report and filter the report to the affected
locations, however, I cannot show the page numbers at the bottom of the page
because it would look something like page 1 of 3, but there might be 60
pages in the completed report. Plus, I need the total number of pages on
the signature sheet with the date the report was updated.

I guess the easiest way to achieve this will be to open the Location report
filtered to the specific location with the current date of the update. Then
on the OnClose Event open up the complete report and notify the user to
print the last page of the report to get the signature page with the
matching date of the update and the page count of the entire report.

 

[Duane Hookom]

Do you want a page count as if the report has less of a filter than what
should actually be printed?

If so, is there any way that you could calculate the number of pages based
on the number of groups and details?

 

[Duane]

What I am looking for is a way to allow the user to print a report of the
affected Location. A Work Area may have 1 to 20 different locations. The
Tool Control Officer may update only one Location in the Work Area, however,
depending on the amount of additions or deletions, the total pages count may
vary for the entire Work Area. If the Work Area inventory contains 60
pages, I don't want the user to have to print up the entire Work Area
report. I would like for them to print the desired Location and then print a
signature page.

I would like the total number of pages on the signature page, along with the
current date, which would be the most recent update. Each page would not
have a page number but the signature page would have the page count. Each
newly printed Location page would be inserted into the entire report (with
the Tool Control Officers initials), replacing the changed pages, and each
page would have the same date as the signature page.

Each Work Area has a different number of locations and there is a different
number of records in each detail. I have thought about getting a page count
using ADO, but the number of records on a page or Locations are virtually
never the same.

What would be the ticket is if the Report could be opened (not filtered) in
hidden view, and through the use of code go to the last page, and print the
last page only, then close the report. That way, when the user closed the
Location report, they would be asked if they wanted to print up a new
signature. If they say yes, the complete report opens behind the scenes and
navigates to the last page and prints the last page only.

Thanks for your help and thoughts.

 

[Duane]

What I am looking for is a way to allow the user to print a report of the
affected Location. A Work Area may have 1 to 20 different locations. The
Tool Control Officer may update only one Location in the Work Area, however,
depending on the amount of additions or deletions, the total pages count may
vary for the entire Work Area. If the Work Area inventory contains 60
pages, I don't want the user to have to print up the entire Work Area
report. I would like for them to print the desired Location and then print a
signature page.

I would like the total number of pages on the signature page, along with the
current date, which would be the most recent update. Each page would not
have a page number but the signature page would have the page count. Each
newly printed Location page would be inserted into the entire report (with
the Tool Control Officers initials), replacing the changed pages, and each
page would have the same date as the signature page.

Each Work Area has a different number of locations and there is a different
number of records in each detail. I have thought about getting a page count
using ADO, but the number of records on a page or Locations are virtually
never the same.

What would be the ticket is if the Report could be opened (not filtered) in
hidden view, and through the use of code go to the last page, and print the
last page only, then close the report. That way, when the user closed the
Location report, they would be asked if they wanted to print up a new
signature. If they say yes, the complete report opens behind the scenes and
navigates to the last page and prints the last page only.

Thanks for your help and thoughts.

 

[Duane Hookom]

I would expect the number of locations etc to change but you don't seem to be
answering my questions. Perhaps I'm not asking them correctly.

Are the report sections set to allow growing? If so, can they be set to not
allow growing and shrinking? If the sections can't grow, you might be able to
get a "page count" by determining the number of sections times their height.

Why do you need a total page count when you don't have page numbers on any
but the last page of your report?

 

[Duane]

I am sorry, I thought I did answer your question.

-Each Work Area has a different number of locations and there is a different
-number of records in each detail. I have thought about getting a page
count
-using ADO, but the number of records on a page or Locations are virtually
-never the same.

Everything is subject to change including the number of Locations. The Work
Area may install another tool box or wall partition - creating yet another
Location. The can grow and can shrink properties are all set to no.

As for the page count - good question. I have been asking them (bosses) the
same question. I don't know how you would ever print a Location with a page
count and insert it into the rest of the report. They page counts would
never match up. You would have page 1 of 60, 2 of 60 - and then the
replaced Location would be 1 of 3 stuck right in the middle.

Thanks again for your thoughts.

 

[Duane Hookom]

Your first post made it sound like Page of Pages only displayed in the final
page of the report with no Page on any of the other pages. Now I am thinking
that each page has a Page number which you need to be displayed and may not
necessarily begin with 1. Is this correct?

If this is what the pointy-haired bosses want, tell them your time is much
more valuable than some extra pages and laser toner.

I expect you could work around this since your sections can't grow. You
should be able to calculate the number of sections that would be renderd but
I don't think it would be worth your time.