Sep 20 2011, 11:16 PM
I have a report (Report A) that is based on a table and returns a line of data for each record in the table. It is working just as intended.
I am now trying to use Report A as a subreport on main report (Report B). I have created referencing text boxes from Report B to Report A, however, I only get the first line of data from the subreport. I tried this in the detail section of the main report and in the header section of the main report but only get the first line of data from the subreport.
Is it possible to pull each line of data from the subreport into the main report?
Sep 21 2011, 12:22 AM
"Is it possible to pull each line of data from the subreport into the main report" I think so, but why would you do that? You have a subreport that already displays each row of data in the form's recordsource. What would be gained by repeating each row again in the main report?
Tell us the desired outcome here and perhaps we can help you get to that solution. Are you looking for summary data in the main report, for example? Or something else?
Thanks for giving us enough information to be able to offer suggestions.
Sep 21 2011, 06:04 AM
In this instance Report A, the sub report, is a lengthy accounting report used to analyze job costing.
Report B would be a detailed by job journal entry based on the calculations in Report A that would be exportable to excel and then used to import into the ERP system.
Report A will NOT show on Report B and will NOT be visible on Report B at all.
Sep 21 2011, 09:47 AM
Sorry, but now I'm more confused. "Report A will NOT show on Report B and will NOT be visible on Report B at all."
Why would you include it if it isn't going to be visible? Are you trying to get the DATA in it into the Main Report? If that's what you need, then the report's RECORDSOURCE would provide it and that's where I'd be looking.
"detailed by job journal entry based on the calculations " in the subreport. This is where you could look at a variation on the query that provides details to to the subreport which you can use in the main report.
"exportable to excel " Again, this suggests a query, not a report, would be the right approach to get the data organized as you need for exporting to Excel.
Sep 22 2011, 10:03 PM
Thank you. I can see a query would be a better solution.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here