Microsoft Access automatically creates a subdatasheet when you create a table that matches one of the following criteria: The table is in a one-to-one relationship. The table is the 'one' side of a one-to-many relationship, where the table's SubdatasheetName property is set to Auto.
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?????
Exporting Data From Access To Excel
I appreciate the help. This is definitely the opposite of 'the usual'. The subreport (totals) gets exports, but not the main report.Exporting the query directly is undersireable as the report format is wanted.I'm wondering if this matters.
Access Export Subdatasheet To Excel Document
Both the report and subreport rely on Access queries. Just cause 3 dual tether controls pc. The main report is a SQL Server SP, the subreport uses a totals query in the main report's SP.
I'm going to do a bit of testing with that.Here's a screenshot of the main and sub reports. Obviously, the main report should have details and be much larger.