Export Report and SubReport to Excel

S

Steve

I have a report in Access that is grouped by ITEM. The group footer consists
of a subreport linked to the ITEM providing additional detail. When the user
exports this to Excel - columns A thru H are the main report ITEM in row 1.
In row 2, the subreport info goes correctly to row 2, but instead of filling
in columns A thru H again, it starts at column I. So, the subreport export
to the right of the main report. Is there any mechanism available to me
where I can control that export and where the info goes? Any tips or ideas?

thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide subreport and main report record if subreport running sum is zero 9
Using Subreports to create a Main Report 1
Output report with a subreport 0
Reports and SubReports Spacing 6
Subreport page break in label controls or textbox controls 6
Report/Subreport Problems with Sorting/Grouping, Access 2003 2
Subreports 1
SynNeed to account for null values in subreports 2

Top