How to output all input files as it is in different sheets of a report (render)?

[ShantanuDagar]

Hello,

So I am facing this 1 issue.

I have 1 report where multiple pivots are created using different input files and are stacked over top of each other with separate header text for each table. And it is output in sheet "ABC".

And there were 4 main base input files on which the pivot tables are created, so 4 pivots stacked over each other in sheet "ABC". 

I need to combine all 4 sheets in my final output as it is with sheets ABC, M,N,O.

Biggest issue is adding M,N,O through tables, layouts, formula and unions is truncating many columns as per the custom size which is perfect for actual "ABC" report. If I increase that, then the pivot gets like super stretched, unable to even read properly.

So get the input files as it is in final output file without messing with the actual size of the "ABC" report right now and to be a sheet later.

[geraldo]

@ShantanuDagar 

when there are several sheets I set the render tool to the largest sheet.
the other tables tool I say join with a report text tool and adjust the table's percentage with the percentage of the report text to get an ideal size

[ShantanuDagar]

Tried it but still giving similarly overstretched report if go with the largest sheet.

[geraldo · Accepted solution]

@ShantanuDagar 

Below is an example workflow of how I adjust the smaller tables to be adjusted not acceptable layout

may not be the best solution but it's the one I use to adjust

[ShantanuDagar]

Thanks @geraldo