[AccessD] A2000: Subreport in Group footer (swe)

Charlotte,

Thank you for the reply. I've been messing around with it. The
subreport, indeed, does show up only if I UNLINK the subreport from
the main report. However, I get all the data instead of just the
records for the group. Then, when I do the Link Child Fields / Link
Master Fields thing, the subreport is invisible again.

Does this suggest anything to you?

Steve Erbach
Neenah, WI


On Wed, 9 Feb 2005 11:30:59 -0800, Charlotte Foust
<cfoust at infostatsystems.com> wrote:
> You should be able to do it in Access as well.  If it runs on its own,
> that means that something isn't right with the data, the code, or the
> links.
> 
> Charlotte Foust
> 
> 
> -----Original Message-----
> From: Steve Erbach [mailto:erbachs at gmail.com]
> Sent: Wednesday, February 09, 2005 10:07 AM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] A2000: Subreport in Group footer (swe)
> 
> Dear Group,
> 
> I'm converting a Paradox for Windows app to Access 2000. One of the
> Paradox reports I'm converting is pretty complex. It not only has a
> couple of subreports in the Report footer, but it even has one in a
> Group footer. That is, there's a one-to-many relationship between the
> data in the subreport and the grouping. That is, there are multiple
> records that display in the subreport for each group footer.
> 
> I believe that I've structured the subreport properly. The ones in the
> report footer work as expected. But when I position the subreport in the
> group footer and run the report nothing appears in the group footer
> other than the standard subtotals that were already there.
> 
> Is this something that Access doesn't handle well? The link Child and
> Master fields worked all right. The subreport works all right when it
> runs on its own. It's just when it's placed in a group footer that it's
> a no-show.
> 
> Any ideas?
> 
> --
> Regards,
> 
> Steve Erbach
> Scientific Marketing
> Neenah, WI
> www.swerbach.com
> Security Page: www.swerbach.com/security
> --
> 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
> 


-- 
Regards,

Steve Erbach
Scientific Marketing
Neenah, WI
www.swerbach.com
Security Page: www.swerbach.com/security