A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Multiple Pages in a Subreport



 
 
Thread Tools Display Modes
  #1  
Old September 27th, 2004, 09:15 PM
Fid
external usenet poster
 
Posts: n/a
Default Multiple Pages in a Subreport

Hi,

I have a report with a Column Header, Subreport as for Detail, and a Column
Footer

HEADER [Client Field]
DETAIL - Transaction Information SUBREPORT
FOOTER [Cliend Field] - Totals, Sums, etc

the SUBREPORT has:
REPORT HEADER
DETAIL - Individual Transaction Lines
REPORT FOOTER - SubTotals of Transactions, etc

works great until the # of transaction lines goes beyond what will fit on a
page then it goes haywire and displays infinity blank pages with only Client
headers

The Report Detail is set to Can Grow = true. i have tried every possible
combo i can think of to allow the SubReport to span across multiple Report
pages. Any clues?

Thanks in advance
Fid





  #2  
Old September 27th, 2004, 09:48 PM
Fons Ponsioen
external usenet poster
 
Posts: n/a
Default

Hi.
I think that you may have set new page before or after in
some of the footers on your main report or the subreport.
However from your description I can not pinpoiint where it
is. Look at the new page properties of the various report
bands and set them to none, than change them one at the
time to obtain the desired results if necessary.
Hope this helps.
Fons
-----Original Message-----
Hi,

I have a report with a Column Header, Subreport as for

Detail, and a Column
Footer

HEADER [Client Field]
DETAIL - Transaction Information SUBREPORT
FOOTER [Cliend Field] - Totals, Sums, etc

the SUBREPORT has:
REPORT HEADER
DETAIL - Individual Transaction Lines
REPORT FOOTER - SubTotals of Transactions, etc

works great until the # of transaction lines goes beyond

what will fit on a
page then it goes haywire and displays infinity blank

pages with only Client
headers

The Report Detail is set to Can Grow = true. i have

tried every possible
combo i can think of to allow the SubReport to span

across multiple Report
pages. Any clues?

Thanks in advance
Fid





.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Countif from multiple pages Clyde Lomax Worksheet Functions 4 August 4th, 2004 01:42 AM
Form code to print multiple pages EdS Running & Setting Up Queries 0 June 10th, 2004 08:30 PM
Keep Top Row Heading for printing multiple pages G118 Worksheet Functions 1 October 7th, 2003 11:56 PM
column headings for multiple pages in Excel Claudia Worksheet Functions 2 October 7th, 2003 06:54 PM


All times are GMT +1. The time now is 06:37 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.