S
Steve
Here is my general questions: On a report, why does the page footer
information NOT appear when the pagefooter property is set to "Not with Rpt
Ftr" and the ReportFooter.visible = false?
Background:
Specifically, I have an invoice setup with the following sections:
Report Header: NONE
Page Header: heading section to appear on ALL pages of the report, except
the Report Footer
Detail: List of items ordered
Page Footer: Footer to appear on ALL pages of the report, except the Report
Footer
Report Footer: A full page of information (it's mercahndise return
instructions) that fills an entire page.
Based upon the usage I am going to describe below, "Have I set it up is a
"code efficient" manner"
This one report is used to print invoices for TWO different types of
customers.
Type 1 customer: The invoice is printed, but the report footer is NOT
printed becaus ethis customer does NOT require that additional page
Type 2 customer: The invoice is printed, AND the report footer is printed.
The problem I have is that the page footer is NOT printing in the correct
situation:
The report parameters "pagerheader" and "pagefooter" BOTH are set to "Not
with Rpt Ftr"
When Type 2 Invoice is printed, the report looks great! The first 3 pages
of the report all show the header/detail/footer on each page, and the the
last page of the report is the report footer, which displays on its own
WITHOUT the pageheader and without the pagefooter.
However, when Type 1 Invoice is printed, I do NOT want to show the Report
Footer, so in the report on open event, I specify "me.reportfooter.visible =
false". The problem, is that when the reportfooter.visible is set to false,
it causes the PAGE footer to ALSO be not visible. I am not sure why, but I
think the report interprets a non-visible report footer as an INVISIBLE
report footer on the main report? This would then cause the page footer to
be NOT visible since it is set to "Not with Rpt Ftr"?
As a work around, I have setup the report so that when the report is to
open, it does the following:
1) opens in design mode, hidden, and changes the "pagefooter" property as
follows:
If Type 1 customer, sets pagefooter to "All pages" and then saves
the report and closes it
If Type 2 customer, sets pagefooter to "Not with Rpt Ftr" and then
saves the report and closes it
2) opens the report in normal mode.
This seems to have been a workaround to the problem.
However, I do not like having to open a report in design mode in teh
background and change the report properties. Especially is all of teh users
are doing this as well.
Is there a more "code efficient" way to address this? Why does the page
footer NOT show up when the pagefooter property is set to "Not with Rpt Ftr"
and the ReportFooter.visible = false?
information NOT appear when the pagefooter property is set to "Not with Rpt
Ftr" and the ReportFooter.visible = false?
Background:
Specifically, I have an invoice setup with the following sections:
Report Header: NONE
Page Header: heading section to appear on ALL pages of the report, except
the Report Footer
Detail: List of items ordered
Page Footer: Footer to appear on ALL pages of the report, except the Report
Footer
Report Footer: A full page of information (it's mercahndise return
instructions) that fills an entire page.
Based upon the usage I am going to describe below, "Have I set it up is a
"code efficient" manner"
This one report is used to print invoices for TWO different types of
customers.
Type 1 customer: The invoice is printed, but the report footer is NOT
printed becaus ethis customer does NOT require that additional page
Type 2 customer: The invoice is printed, AND the report footer is printed.
The problem I have is that the page footer is NOT printing in the correct
situation:
The report parameters "pagerheader" and "pagefooter" BOTH are set to "Not
with Rpt Ftr"
When Type 2 Invoice is printed, the report looks great! The first 3 pages
of the report all show the header/detail/footer on each page, and the the
last page of the report is the report footer, which displays on its own
WITHOUT the pageheader and without the pagefooter.
However, when Type 1 Invoice is printed, I do NOT want to show the Report
Footer, so in the report on open event, I specify "me.reportfooter.visible =
false". The problem, is that when the reportfooter.visible is set to false,
it causes the PAGE footer to ALSO be not visible. I am not sure why, but I
think the report interprets a non-visible report footer as an INVISIBLE
report footer on the main report? This would then cause the page footer to
be NOT visible since it is set to "Not with Rpt Ftr"?
As a work around, I have setup the report so that when the report is to
open, it does the following:
1) opens in design mode, hidden, and changes the "pagefooter" property as
follows:
If Type 1 customer, sets pagefooter to "All pages" and then saves
the report and closes it
If Type 2 customer, sets pagefooter to "Not with Rpt Ftr" and then
saves the report and closes it
2) opens the report in normal mode.
This seems to have been a workaround to the problem.
However, I do not like having to open a report in design mode in teh
background and change the report properties. Especially is all of teh users
are doing this as well.
Is there a more "code efficient" way to address this? Why does the page
footer NOT show up when the pagefooter property is set to "Not with Rpt Ftr"
and the ReportFooter.visible = false?