Report Link fields

[Guest]

I have a report that I have translated from and MDB into an ADP which has a
couple of subreports that sit in a group header and footer. It uses the Link
Child Field, Link Master Field features to filter the data displyed data
according to the Master record value. This feature does not work as it does
not restrict the data according to the links. This feature works fine in MDB
reports, but I have tried it a couple of times and can't get it to work for
ADP's. Is there some trick to getting this to work in an ADP. Alternatively
is there some work around that can be implemented to make this work?


For further information I am using Office 2003.

 

[Sylvain Lafontaine]

Child Field and Link Master should work only when the record source for the
subreport is a table (and maybe also with a simple sql query but I'm really
not sure here) and shouldn't work when the record source is a stored
procedure or an EXEC sql statement.

The easiest way to work with subreport in ADP is to use stored procedures as
the Record Source with parameters with the same name as one or more fields
on the main report. Even if you don't intend to display them, these fields
should have their own textbox on the main report (making them hidden if
necessary).

 

[Tony Wickernark]

I've used a subreport / subform bound to a stored procedure before; and it
automagically binds the parameters based on field names I think

it worked quite well IMO

 

[Guest]

Thanks for that. Using the paramater worked perfectly.