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

Steve Erbach erbachs at gmail.com
Wed Feb 9 16:35:50 CST 2005


Stuart,

The spaces in the field name was the problem! I changed the Record
Sources for both the main report and the subreport so that the [Source
Number] field became SourceNumber, re-linked, and voila! She works!
Thank you.

Steve Erbach
Neenah, WI


On Thu, 10 Feb 2005 08:18:11 +1000, Stuart McLachlan
<stuart at lexacorp.com.pg> wrote:
> On 9 Feb 2005 at 15:57, Steve Erbach wrote:
> 
> > Charlotte,
> >
> > The report has an outer Group based on [Source Number] (Text). There
> > is an inner group, too, on [Facility Part #] (also Text).
> >
> > The subreport's data source includes all the fields from one table.
> > The first field of that table is [Source Number], however that field
> > doesn't appear in the subreport; just four other fields. I did place
> > the [Source Number] field on the report, though, hidden behind the
> > other fields just in case that was the problem. But the subreport
> > still won't show up.
> 
> You do need the field as a hidden field in the sub report. Keep it there.
> 
> >
> > So, on the main report:
> >
> > Source Object: Report.rptSubStateCAS
> > Link Child Fields: Source Number
> > Link Master Fields: Source Number
> >
> > I've tried surrounding the Source Number field name with square
> > brackets, too, but no go.
> >
> 
> You should do that too. FWIW, you should avoid spaces in fieldnames -they
> can turn around and bite you in so many ways :-(



More information about the AccessD mailing list