Is it possible to have the same subreport appear multiple times in a single report, but have each instance report data from different dropdowns on my form?
I have a form with several dropdowns (addressdropdown1, addressdropdown2, addressdropdown3, etc.) through which the user can select a name. The subreport needs to read the name and report out address information.
This works perfectly for the first instance of the subreport. The subreport sees the value in addressdropdown1 and reports the address information.
I am having a problem with the second instance of the same subreport. I want it to read the value in addressdropdown2 and report the address information, but when I go to add the subreport for the second time (using the SubForm/SubReport button on the report design Toolbox) it simply places a copy of the first subreport and reports out the same data as the first subreport. I can't seem to get it to know that it should be looking at addressdropdown2 and when the subreport is added, the SubReportWizard skips the step asking me how to link the reports.
Any thoughts?
I have a form with several dropdowns (addressdropdown1, addressdropdown2, addressdropdown3, etc.) through which the user can select a name. The subreport needs to read the name and report out address information.
This works perfectly for the first instance of the subreport. The subreport sees the value in addressdropdown1 and reports the address information.
I am having a problem with the second instance of the same subreport. I want it to read the value in addressdropdown2 and report the address information, but when I go to add the subreport for the second time (using the SubForm/SubReport button on the report design Toolbox) it simply places a copy of the first subreport and reports out the same data as the first subreport. I can't seem to get it to know that it should be looking at addressdropdown2 and when the subreport is added, the SubReportWizard skips the step asking me how to link the reports.
Any thoughts?