[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
>