John W. Colby
jwcolby at colbyconsulting.com
Wed Feb 9 14:43:31 CST 2005
It suggests you are not pulling any data for the subreport. John W. Colby www.ColbyConsulting.com Contribute your unused CPU cycles to a good cause: http://folding.stanford.edu/ -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Erbach Sent: Wednesday, February 09, 2005 3:31 PM To: Access Developers discussion and problem solving Subject: Re: [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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com