Discussion Locked

Exporting subreports into Excel

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
When I export my report into MS Excel, everything can be formatted correctly, except one field that I had to create a subreport for (this seems to be the only way to incorporate this information). In Excel this one field automatically creates a new row in the spreadsheet and cannot be viewed on the same row as the rest of the data that pertains to it. Is there any way to correct this issue or format the exporting of the report in such a way that it won't continue to do that? Thanks.

1 reply

by misscrf

My question is what are you exporting from? I am going to assume Access as I attempt to offer a possible solution. My best bet would be to import the subreport separately onto its own sheet, and then just reference it on the other sheet. Then it will show like a sub report, while coming in the way that Excel better understands it.

This discussion is closed to new replies.