General discussion

Locked

Exporting subreports into Excel

By mdugger ·
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.

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by misscrf In reply to Exporting subreports into ...

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.

Back to Software Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums