[AccessD] Raising events from subreports

OK, this report is actually a long letter explaining benefits adjustments.
It has a standard header (one in each language) for each claim, detail of
the adjustments, which has to show up in each language version, a total of
the amounts involved, and explanation of each of the adjustments in that
particular claim (in each language).  Right after the explanation comes
several pages of standard boilerplate (in each language) and another bit of
boilerplate (in each language) that lists legal aid providers in the county
of the claim.  It has to print first as two separate letters, one in
English and one in Spanish for each claim.

The parent form is a shell containing the individual subreports and
juggling them to print the same detail information and boilerplate, once in
English and once in Spanish.  The subreports are either English or Spanish
versions.  The only things that are not translated between the letters is
the detail of the amounts and the legal aid addresses.  The codes,
explanations, descriptions, etc. are toggled for language.

Sound complicated enough for you?  The primary subreport has the language
version of the letter header, detail of the adjustments, and a subreport
containing the explanations peculiar to the adjustments in that claim in
that language.  This is the only nesting in the subreports, and it works
nicely.  The problem arises when the detail pushes onto a second page.  I
can easily identify in the subreport when the entire print length so far
will force a page break by keeping an accumulative variable that adds the
printed height of each detail record.  What I can't find a good way to do
is let the parent know.  We're emulating a Word document here, so I'm
trying to find a way to keep labels together.  They have to be separate
labels for font size and formatting.

Charlotte

On Sat, Mar 24, 2012 at 6:10 AM, Jim Dettman <jimdettman at verizon.net> wrote:

> Charlotte,
>
> <<Subreports are nested no more
> than 3 deep, but I need to find a way to deal with child level subreports
> that cover multiple pages. >>
>
>   In what way?  After reading your description, I'm still left wondering
> what it is your trying to do/avoid when the sub reports print.
>
> Jim.
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
> Sent: Saturday, March 24, 2012 02:45 AM
> To: Access Developers discussion and problem
> Subject: Re: [AccessD] Raising events from subreports
>
> Here's the issue:  I have a report with multiple subreports for individual
> parts of the docuent, including detail specific to each subreport and
> boiler plate that runs to about 3-4 pages..  Subreports are nested no more
> than 3 deep, but I need to find a way to deal with child level subreports
> that cover multiple pages.  I'd like to know when that condition occurs,
> which I can determine within the Print event of the Detail section of the
> subreport by testing overall cumulative height against a maximum number of
> twips.  I just haven't found a good way of passing the information back to
> the parent form in order to force a page break.  Page breaks don't work in
> subreports, so  it has to be done at the parent level, and I'm banging my
> head against the problem.
>
> Charlotte Foust
> On Fri, Mar 23, 2012 at 5:59 PM, Charlotte Foust
> <charlotte.foust at gmail.com>wrote:
>
> > Has anyone had luck raising custom events from subreports to their parent
> > reports?  I used to do it in VB.net but Access report objects play by
> > different rules.
> >
> > Charlotte Foust
> >
> --
> 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
>
>
>