Determining print location at print time

  • Thread starter Thread starter C Lane
  • Start date Start date
C

C Lane

I have a reprot that has Report,Page, and Detail header
areas.
The detail section contains several sub-reports. Every so
often one of these sub-reports prints toward the bottom of
the page but is obscured by the page footer and this data
is not visible.

Is there a way to determine the absolute location of an
item that is about to print. Not its locatoin within the
detail section but its location on the page so that if it
is below a given location I can move to the next page?
 
C said:
I have a reprot that has Report,Page, and Detail header
areas.
The detail section contains several sub-reports. Every so
often one of these sub-reports prints toward the bottom of
the page but is obscured by the page footer and this data
is not visible.

Is there a way to determine the absolute location of an
item that is about to print. Not its locatoin within the
detail section but its location on the page so that if it
is below a given location I can move to the next page?
Click to expand...


That shouldn't happen. You may have something funny going
on with your video/printer drivers or maybe(?) a font
metrics issue.

One thing you could do is create a separate section for each
subreport by adding group levels based on the detail
record's sort field, adding a header and footer for each
level and placing each subreport in its own section. This
way you might get what you want by setting the section's
KeepTogether property. If the KeepTogether is too
restrictive, then you can use code in the section's Format
event that checks the report's Top property to determine
where on the page the section starts.
 
-----Original Message-----
C said:
I have a reprot that has Report,Page, and Detail header
areas.
The detail section contains several sub-reports. Every so
often one of these sub-reports prints toward the bottom of
the page but is obscured by the page footer and this data
is not visible.

Is there a way to determine the absolute location of an
item that is about to print. Not its locatoin within the
detail section but its location on the page so that if it
is below a given location I can move to the next page?
Click to expand...


That shouldn't happen. You may have something funny going
on with your video/printer drivers or maybe(?) a font
metrics issue.

One thing you could do is create a separate section for each
subreport by adding group levels based on the detail
record's sort field, adding a header and footer for each
level and placing each subreport in its own section. This
way you might get what you want by setting the section's
KeepTogether property. If the KeepTogether is too
restrictive, then you can use code in the section's Format
event that checks the report's Top property to determine
where on the page the section starts.
--
Marsh
MVP [MS Access]
.
I had tried this in the past but with 23 subreports I did
Click to expand...
not have any luck. But i did just try something that
seems to have solved to over printing problem. I took the
keep together off the detail break and the problem is no
longer there. I will have to do some more testing as not
every report has informantion for all subreports.
 
Back
Top