William Hindman
wdhindman at bellsouth.net
Mon May 5 22:56:05 CDT 2003
...take a look at KB 292050 ...HTH :) William Hindman ----- Original Message ----- From: "Charlotte Foust" <cfoust at infostatsystems.com> To: <accessd at databaseadvisors.com> Sent: Monday, May 05, 2003 4:18 PM Subject: RE: [AccessD] Sub-Reports and Paging > Rocky, > > If you find an answer, please share it with me! We've struggled with > this question and have never found a satisfactory answer ... > particularly since we also hide subreports that have no data, which > moves the ones below them up and ... well, you get the idea, I'm sure. > > Charlotte Foust > -----Original Message----- > From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com] > Sent: Monday, May 05, 2003 11:26 AM > To: accessd at databaseadvisors.com > Subject: Re: [AccessD] Sub-Reports and Paging > > > Brett: > > Thanks for your reply. > > I don't want to force a page break between each sub-report. Sometimes > they're only one line. so they need to all flow together unless it's > close to the bottom of the page. In that case the header text (4-6 > lines) gets split over two pages (sometimes in the middle of the line > horizontally!) and sometimes it will do this to a detail line. > > Any idea how to 1) prevent that and 2) to force a page break when close > to the bottom of the page but not page break when in the sub report > starts in the middle of the page? > > Thanks and regards, > > Rocky > > ----- Original Message ----- > From: Brett Barabash > To: 'accessd at databaseadvisors.com' > Sent: Monday, May 05, 2003 10:22 AM > Subject: RE: [AccessD] Sub-Reports and Paging > > > Rocky, > Normally, I create a section for each subreport. This allows me full > control over the page breaks: > - In the Sorting And Grouping box, type ="My Section" (call it whatever > you want, extra points for being descriptive), and set Group Header = > Yes. This will create a report header where you can place your > subreport. > - In the Report Header property sheet, set Keep Together = Yes. Don't > forget to set your Can Grow and Can Shrink properties. > - Voila! Access will not split a subreport in this section between 2 > pages. Plus, if you want to force a page break at the start of a > subreport you can easily do that by setting the section's Force New Page > property. > > P.S. Access allows up to 10 headers and 10 footers per report. They can > be referred to using the Me.Section property using the following > indices: > Me.Section(5) - Group header # 1 > Me.Section(6) - Group footer # 1 > Me.Section(7) - Group header # 2 > Me.Section(8) - Group footer # 2 > ... > -----Original Message----- > From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com] > Sent: Monday, May 05, 2003 9:49 AM > To: accessd at databaseadvisors.com > Subject: Re: [AccessD] Sub-Reports and Paging > > > Dear Rocky: > > Perhaps you could put an invisible page break between each sub-report. > Then in the OnOpen event of the report, Dcount the records in each of > the eight sub-reports and estimate the height of the sub-report from the > sub-report's report header plus the number of detail records. Then make > the page break visible to separate the sub reports. > > Of course since one of the fields in the detail record 'can grow' and > does, it's going to be an estimate at best. Also, this means > potentially a lot of white space on a page. Nah, that won't really work > well. You need to know where you are on the page during the printing of > the sub-report and page when it gets close to the bottom. > > Maybe someone else has an idea. > > With my very best regards for you and your family, > > Rocky Smolin > Beach Access Software > > ----- Original Message ----- > From: Rocky Smolin - Beach Access Software > To: AccessD at databaseadvisors.com > Sent: Friday, May 02, 2003 5:18 PM > Subject: [AccessD] Sub-Reports and Paging > > > Dear List: > > I have a report that consists of eight sub reports. Each sub-report can > be of a different length. Each sub-report has a report header with some > descriptive text. > > The problem is that the main report page breaks in odd places sometimes > even cutting a line of the subreport in half horizontally! > > I can, of course, insert an invisible page break between each sub-report > and make it visible if I'm close to the bottom of the page. But I don't > know how to know, during the printing of the sub-report, where I am on > the main report. > > Anybody got any ideas? > > MTIA, > > Rocky Smolin > Beach Access Software > > > > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > > > ------------------------------------------------------------------------ > -------------------------------------------- > This email and any files transmitted with it are confidential and > intended solely for the use of the individual or entity to whom > they are addressed. > If you have received this email in error please notify the > originator of the message. This footer also confirms that this > email message has been scanned for the presence of computer viruses. > > Any views expressed in this message are those of the individual > sender, except where the sender specifies and with authority, > states them to be the views of Tappe Construction Co. > > Scanning of this message and addition of this footer is performed > by SurfControl E-mail Filter software in conjunction with > virus detection software. > > > > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com