Fixed length detail section

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to keep the detail section of a report at a fixed length? My detail section prints a varying number of records (from 1 to 5) per page and this causes the vertical starting position of the next section, a group footer, to float. The starting print position of the next section must be the same on every page because the report is printing on a paper form that has perforated sections

ctda
 
ctdak

In the design view, limit the size of the detail section
to fit the 5 records. Then set the fields(s) "Can Grow"
property to "NO" and the "Can Shrink" property to "Yes".
Good Luck

Bart
-----Original Message-----
Is there a way to keep the detail section of a report at
Click to expand...
a fixed length? My detail section prints a varying number
of records (from 1 to 5) per page and this causes the
vertical starting position of the next section, a group
footer, to float. The starting print position of the next
section must be the same on every page because the report
is printing on a paper form that has perforated sections.
 
ctdak said:
Is there a way to keep the detail section of a report at a fixed length? My detail section prints a varying number of records (from 1 to 5) per page and this causes the vertical starting position of the next section, a group footer, to float. The starting print position of the next section must be the same on every page because the report is printing on a paper form that has perforated sections.
Click to expand...


Let me suggest that this problem is best addressed by using
a record source query that guarantees 5 records for each
group.

I can imagine such a query, but I think you would be better
off rephrasing your question and asking it in the queries
newsgroup
 
Bart

Thanks much for your answer. I had seen these properties but didn't know if they pertained to what I was doing or not. I had to play around with them for a while because I have two sub-reports imbedded in my main report's detail section and they all interplay, but I got it to work finally. You steered me in the right direction
Thanks

ctda

----- Bart wrote: ----

ctda

In the design view, limit the size of the detail section
to fit the 5 records. Then set the fields(s) "Can Grow"
property to "NO" and the "Can Shrink" property to "Yes".
Good Luc

Bar
-----Original Message----
Is there a way to keep the detail section of a report at
Click to expand...
a fixed length? My detail section prints a varying number
of records (from 1 to 5) per page and this causes the
vertical starting position of the next section, a group
footer, to float. The starting print position of the next
section must be the same on every page because the report
is printing on a paper form that has perforated sections
 
Marsh,

I’m afraid your suggestion won’t work. There’s no way to come up with 5 records per group. By the nature of the data, there are from 1 to 5 records per group and there’s no way around that. The problem to solve is one of print positioning. The suggestion made by Bart in this regard, using the Can Grow and Can Shrink properties (of the report sections, not fields), solved it.

Thanks for answering anyway. Your answers on other questions have helped me out a great deal.

ctdak

----- Marshall Barton wrote: -----
Is there a way to keep the detail section of a report at a fixed length? My detail section prints a varying number of records (from 1 to 5) per page and this causes the vertical starting position of the next section, a group footer, to float. The starting print position of the next section must be the same on every page because the report is printing on a paper form that has perforated sections.
Click to expand...


Let me suggest that this problem is best addressed by using
a record source query that guarantees 5 records for each
group.

I can imagine such a query, but I think you would be better
off rephrasing your question and asking it in the queries
newsgroup
 
ctdak said:
I’m afraid your suggestion won’t work. There’s no way to come up with 5 records per group. By the nature of the data, there are from 1 to 5 records per group and there’s no way around that. The problem to solve is one of print positioning. The suggestion made by Bart in this regard, using the Can Grow and Can Shrink properties (of the report sections, not fields), solved it.

Thanks for answering anyway. Your answers on other questions have helped me out a great deal.
Click to expand...


Glad you got it working.

I completely missed the part of your question about these
records being in a subreport, so Bart's approach never
entered my mind. Sorry about any confusion I might have
caused.

OTOH, I have to disagree about there being no way to come up
with 5 records. I am certain that a (pretty complicated)
query could be used to manufacture blank records for use in
the report.
 
Back
Top