Search results

Hi there, I found solution for this. The problem was that former report layout was original report access "sheet" with additional 2 subreports and the subreports were shifted. But when I changed it to "blank sheet" with 3 subreports, it is fixed. So the problem is solved, thanks for your assistance.

If I would decide, I would not do it that way for sure, but my colleagues are used to use Excel so they export this report into excel as well as it fits their needs. I find it also quite weird but I can't do anything with it. I just need to make it optimalized for export to Excel somehow. Could...

Hmm I am not happy to read that but I understand. And could you please give me a example of what are you advicing? Or some hint how to be able to affect the way the data are expoted via VBA? Thanks

Here I created sample access DB with report that has been created exactly with the same pattern like my original one. The attached export behaves exactly as well.

My apologies for that. I really did not have a clue about that this is a problem, I will know next time, thanks. I export it via External data -> Excel. Im going to create sample data DB and post it here in a while.

Hi guys, I have an Access report containing its own "table" part and two additional subreports under with similar content. I tried my best to make the additional reports aligned right under the first one in Access report view. However, as soon as I export it to Excel, the first report is...