Problem exporting Access report with subreport to Excel
Posted on 2013-05-09
I have an Access report which includes a subreport. It prints fine in Access, but when I export it to Excel, the subreport begins in the next row and column of the main report.....example: the main report data is in Excel rows A1 thru Q111 - then the subreport begins in row R112 and uses as many columns as needed to the right (ends in AI113).
Is there any way to make the subreport align directly under the main report - that is to begin in cell R1????? Than x for your help!
p.s. I am NOT exporting using a VBA command - I am merely using the External Data icon to export the report to the Excel file. I could use the VBA command if I could append the subreport to the main report?????