ADP subreport not returning records
Posted on 2006-04-06
I have an ADP report that has two subreports. Neither of the subreports are returning any records. This works fine with a mdb, but not the adp. The report filters to a single master record out of a table containing over 47k records. Each of the subreports contains multiple records for each record in the master.
I've set the LinkChildFields and the LinkMasterFields, but it appears to ignore them.
I'm converting this application from a mdb to adp. Originally I hadn't set the max records to 0, so I only had 10,000 records in each of these tables, but that's now corrected.
I'm using the WhereCondition parameter when calling the main report. Is there a timing issue in filling a field of the subreport that causes the subreport to load (with an empty value for the link field) before the filter is set for the main report?
I've spent a few hours on this and feel pretty dumb at this point. I thought I knew how to build a report in Access. :-s