[AccessD] Sub-Reports and Paging

Can't I just do it until I need glasses?

Rocky

----- Original Message ----- 
From: "William Hindman" <wdhindman at bellsouth.net>
To: <accessd at databaseadvisors.com>
Sent: Monday, May 05, 2003 10:14 AM
Subject: Re: [AccessD] Sub-Reports and Paging


> ...you know talking to yourself leads to hairy palms, eh? :))))
>
> William Hindman
>
> ----- Original Message ----- 
> From: "Rocky Smolin - Beach Access Software" <bchacc at san.rr.com>
> To: <accessd at databaseadvisors.com>
> Sent: Monday, May 05, 2003 9:49 AM
> 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
>
>
>
> --------------------------------------------------------------------------
--
> ----
>
>
> > _______________________________________________
> > 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