Charlotte Foust
charlotte.foust at gmail.com
Fri May 25 20:23:18 CDT 2012
Your problem may be in the data source of the parent report. If the subreports are already bound to the stored procedure, then the parent report should only have a dataset that provides the limited set of customer numbers to be used in the batch. Put a hidden field in the parent detail section to contain the customer number for each report and have the subreport get the parameter value from the parent. Charlotte Foust On Fri, May 25, 2012 at 2:13 PM, David McAfee <davidmcafee at gmail.com> wrote: > I know I have done this before, but at the moment I cannot find one of my > working examples. > > > I've created a report that may be one or more pages. > The report is bound to a stored procedure. > > When prompted for the customer number (the sproc's only input parameter), > the report populates > as expected and displays page 1 of N on the bottom of the page footer. > > The users need to print these reports in batches, so I thought I could drop > in the report as a subreport, linking a master & child field. > > This doesn't seem to work for me. > > The sub report exists in the parent report's detail section. > > I've even created a field in the sub report and pointed it to the > master/parent report using "=Reports!Report2!CustNo" > > Both reports display the CustNo fields correctly, but the data in the child > report(s) is not populating > > I've searched and searched online, and tried the recommendations, but none > seem to work. > > Some of the recommendations are: > > 1. Change the Child report's rowsource to be a View instead of a SPROC and > let the link fields handle the data. Nope. > > 2. Create a field in the Parent report. Name it the same as the sub > report's input parameter (without the @). Nope. > > 3. Populate a field on a hidden form in the OnCurrent/OnFormat event of the > parent report. Make the Input parameter of the sub report look at that > field. Nope. > > Any ideas? > > Both > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > > > Website: http://www.databaseadvisors.com > > >