Multipage Report

[Moses76]

Hi ,
I have a report that has data that bleeds on to the 2nd page . Problem is I dont know how to make it bleed on to the next page . Please guide. I have tried extending the section that is above the page footer section and it does not work . it just repeats the data from the first page multiple times.




Please help.

Thanks.

Moses

 

[boblarson]

Not quite sure what you are referring to when you say it bleeds on to the 2nd page but you don't know how to make it bleed on to the next page. That seems to be saying that it is doing it but you want to do it because it isn't.

Can you post a few screenshots here that show what your report looks like (include design view as well as report view).

See here:
http://www.access-programmers.co.uk/forums/showthread.php?t=194680
for how to upload and display the pics here.

 

[Moses76]

Sorry about the confusing answer . Here it is with the screen shot.

 

[sugarsweetpee]

Hi, your report information should go in the Detail section. It appears (from your screen shot) that you have it all in the report header.

Try putting the data in the section instead. In your screen shot this area has been removed (i.e. you have shrunk the section down till its not really there at all). Start by revealing the detail section then copy and past your data into there.

Hope this helps.

 

[Moses76]

Hi, your report information should go in the Detail section. It appears (from your screen shot) that you have it all in the report header.

Try putting the data in the section instead. In your screen shot this area has been removed (i.e. you have shrunk the section down till its not really there at all). Start by revealing the detail section then copy and past your data into there.

Hope this helps.

Thanks a lot ! Still learning.

 

[gemma-the-husky]

out of interest, what a report does is this, basically

- you can set left/right top/bottom margins, and decide on portrait or lanscapte

- it then puts the page header and footer at the top and bottom of each page, matching the size they are in design mode

- if you have a report header, that goes right at the top on page 1, above the page header.
- a report footer does the same at the bottom, but before the page footer

- the detail section is then repeated as many times as can fit in the gap that is left in the middle of the page

- there is actually rather more than this, but this should help.

- you can manage the way "orphans", and blocks of data are handled in the detail sectiopn, to try and format it, but it is sometimes hard to get stuff positioned exactly precisely.

The other thing that is not possible (maybe it is now after A2003) is to get the details section to include layout vertical and horizontal lines, over the WHOLE detail area, which is awkward at times. I think Stephen Lebans has an add-in solution to this.