Keep Detail section fixed size

[smile]

I have a report that I need to keep Detail section fixed size, when there is enough data to fill it eccess should make page 2 then page 3 etc.

In other words I have full report here with as much records as can fit on 1 page.

If I lave less records I need to make it look like this

Notice the yellow box has same size as before.

I tried to resize detail section but that only increased space for each record, I tried to resize Page and report Footer and to no avail.

I think I need to use

Auto height
Can Grow
Can Shrink

To make it work, but don't know what to select for each section.

Thanks for your help.

 

[gemma-the-husky]

access will do what you want as standard

do you mean you want a new page on each group change

in which case, look at sorting/grouping, then in the properties.format page of the group header, you can specify details on paging

 

[smile]

access will do what you want as standard

do you mean you want a new page on each group change

in which case, look at sorting/grouping, then in the properties.format page of the group header, you can specify details on paging

Well it does not work for me "as standard". The Report footer is moved as close to detail section as possible. And if there are only few records I need it to be in the same place like I have 7 in example above.

If I try to increase detail section size in design view it increases space above and below every record that does not work for me.

If I try to move down report footer in design view it increases space above it and show that it will fit in 1 page in print preview but when I print it it prints on 2 pages.

 

[gemma-the-husky]

sorry

the report footer comes at the end of the report, after all the details, and is therefore spaced close to the last detail item You could force this onto a new page, or have a bit of leading space before it prints. You only get 1 report footer per report.

Ioffhand i can't see a way of locating this at the bottom with the page footer.

The page footer is always at the bottom of the page, occupying the same size. you get one per page.

Perhaps you could put some extra stuff in the pagefooter, that only prints on the last page

 

[Simon_MT]

I not quite sure what purpose the information is going to be used for but if this was invoicing, one solution is to put the information you what to appear in the Page Footer.
You will need to force a new Page on the Order.

If with information may requires Multiple Pages, then if this was Sales information create a Header and Footer for OrderNo. On the OrderNo.Header set all the fields (not the PageFooter itself - doesn't work!) in the PageFooter to Visible=False. On the OrderNo.Footer set them to PageFooter fields to Visible True.

In essence, using the OrderNo example, everytime a new order is encountered the contents of PageFooter is not visible at the end of that order the contents PageFooter become visible.

Later Versions of Access for maybe able to play around with:

.LogicalPageHeight
X and Y values.

Simon

 

[smile]

I not quite sure what purpose the information is going to be used for but if this was invoicing, one solution is to put the information you what to appear in the Page Footer.
You will need to force a new Page on the Order.

If with information may requires Multiple Pages, then if this was Sales information create a Header and Footer for OrderNo. On the OrderNo.Header set all the fields (not the PageFooter itself - doesn't work!) in the PageFooter to Visible=False. On the OrderNo.Footer set them to PageFooter fields to Visible True.

In essence, using the OrderNo example, everytime a new order is encountered the contents of PageFooter is not visible at the end of that order the contents PageFooter become visible.

Later Versions of Access for maybe able to play around with:

.LogicalPageHeight
X and Y values.

Simon

This was for invoice, and can require more than one page sometime.

 

[Simon_MT]

I've been away, so forgive that late reply.

I would suggest that you create on your report to handle invoices a InvoiceNo Header and Footer. What you put in these is up to you. As I said, on the Header make the individual Page Footer fields Visible False. On the InvoiceNo Footer make these Page Footer Fields Visible. So for continuations the Footer information will only be visible on completion of each invoice.

Simon

 

[anonymous1]

I know I'm reviving an old thread but I was wondering if anyone came up with solution to keep the Detail section to a fixed size. I need to print gradeslips for a school but it is to be done on a dot matrix printer using carbon paper continuous feed.
I am not sure where I can set a specific size and maintain it. The problem is I don't have the paper size to work with or even test. They would like me to come up with the size (at least 1/2 the size of a regular letter sheet) but unfortunately i have no way of testing except by previewing right now. I have changed margins etc and am ending up with a large white space between my detail and footer sections.
Any help would be greatly appreciated. Thanks.

 

[gemma-the-husky]

well detail IS a fixed size - these are normally 12" paper, 3 to a page

just design the report with just a detail section, select a 12 inch page, no top/bottom margins, and a 4" detail size.

that should work, shouldnt it

 

[HiTechCoach]

Pardon me for jumping in here .....

I think this is what you may need:

How to Print a Constant Number of Lines Per Group

Hope this helps ....

 

[veasnamuch]

I have a report that I need to keep Detail section fixed size, when there is enough data to fill it eccess should make page 2 then page 3 etc.

In other words I have full report here with as much records as can fit on 1 page.

If I lave less records I need to make it look like this

Notice the yellow box has same size as before.

I tried to resize detail section but that only increased space for each record, I tried to resize Page and report Footer and to no avail.

I think I need to use

Auto height
Can Grow
Can Shrink

To make it work, but don't know what to select for each section.

Thanks for your help.

Good afternoon smile,

Do you have any solution for your problem? I have face same problem of you on my pre-printed report.

Could you please guide me to your solution, if your case have been resolved.

Best regards,

Veasna

 

[andrepontes]

You can have just only one large details field with cangrow = false, and internally you put a sobrereport. Then your first upper details will have fixed height. And the sobrereport will be cut if there is not room enough