[AccessD] Access Report

Charlotte Foust charlotte.foust at gmail.com
Tue Jan 18 19:58:56 CST 2011


Use code in the group header to determine if the current subreport is
the last and if so toggle the page break.  I usually turned off the
page break by default, and turned it on for each subreport except the
last one.

Charlotte Foust

On Tue, Jan 18, 2011 at 12:13 PM, David McAfee <davidmcafee at gmail.com> wrote:
> The sub reports only show the detail section, so I've grouped on InvNo
> and added the individual reports header info into the Group's header.
>
> I wanted them to appear as separate pages, so I inserted a page break
> just below the sub report. This works fine, but always displays a blank
> page at the end. Any way to suppress it, if it is the last record?
>
>
>
> On Tue, Jan 18, 2011 at 10:38 AM, Charlotte Foust <charlotte.foust at gmail.com
>> wrote:
>
>> Yup.  Create a new report and create subreport controls for each of
>> the other reports, one per page.  You can use the detail section for
>> the individual reports or put them in a group footer with the summary
>> subreport in a group header.  That would allow you to use a date
>> selection or other kinds of filtering as well.
>>
>> Charlotte Foust
>>
>> On Tue, Jan 18, 2011 at 10:27 AM, David McAfee <davidmcafee at gmail.com>
>> wrote:
>> > I have a summary report that displays invoices ready to be committed as
>> well
>> > as an individual report for any of those invoices.
>> >
>> > When the reports are committed via a command button, they want to see one
>> > report with the summary as the first page(s) then each
>> > invoice that is committed as a new page.
>> >
>> > Any idea how to do this?
>> >
>> > I was thinking a new report with the summary as a subreport in the report
>> > header and the individual report as a subreport in the detail section.
>> >
>> > Is there a better way of doing this?
>> >
>> > David
>> > --
>> > 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
>




More information about the AccessD mailing list