Render multiple report layouts to a single excel sheet with custom render size

[gelvira]

Hello everyone, 

I have couple of questions to understand the tools better and seeking a solution for my use case.

My issue is somewhat similar to this post

But it doesn't solve my problem.  My workflow looks like this:

First Approach:

My excel result:  

Issues-

1. If I try and split my two layout into two tabs in excel, it is splitting the first's layout which had 3 tables into 3 tabs. I want them in the same page. 

2. The 'All Data' is showing errors. If I render by increasing the size then the other tables get expanded and look weird. 

Second Approach: 

Did everything using 'visual layout' for part 1. It makes my flow look way cleaner and one tool joined 3 tables on one sheet. 

Issue: Render size is causing issues. If I don't increase the size then my 'All Data' doesn't show properly and if I do increase the render size then then 'Summary' tables get stretched all the way. 

Third Approach: 

I am trying to use "Output Data" tool. 

I can get 'All Data' in excel properly with this tool but I can't figure out how to get visual layout/ table on the same sheet with Output Data tool. 

Is there any better way to do this? I appreciate any help in this regard!!!