Reporting tools - Table arrangement across sheets

Question

My workflow requires multiple tables per sheet, output into a single report. Here's how I accomplish this :

The expected output is three tables in the sheet named "Data1" and two tables in the sheet named "Data2".

The output looks like this :

Here are the issues I have with this :

* I want the tables side by side, not stacked one on top of another. But using the "Horizontal" orientation in the layout tool doesn't allow me to divide the tables into different named sheets like I want to.
* I'm not able to figure out how to font. The cells are too broad and the contents are at the far right and I'd like them in the center and with the width I want. I tinkered with the configs a bit but nothing seems to do what I want it to. (I'm sure I missed something)

Basically I want it like this :

I tried the overlay tool but I think that might not suit this use case.

Any help would be appreciated!

vj28 · Answer

Thanks for the response Ollie! I remember trying something like this, but it didn't set custom sheet names from the SheetName column I'd created. If I missed something I'll try this again though.

Also the tables sticking together is still kind of an issue. Someone recommended the blob tool option but I've got another project where there are around a hundred pivot tables across several sheets so even creating the template manually in the first place is a pain. I think I'll have to resort to a VBA macro for the formatting (which I dread, because of all the issues that comes with especially in server; but what can ya do..)

OllieClarke · Answer

Hi @vj28

In your layout tool, if you do a horizontal layout for each group of records, then you can get your multiple tables in the same sheet

(looking like this):

In your render tool, you can insert section breaks between records which will write out to multiple sheets

multiple_sheets.xlsx

I didn't look too deep into separating out the tables in the output, but hopefully that's enough to get you started.

Ollie

vj28 · Answer

I'm aware of both of these options, I was just wondering if there was some way to do all this using just the Reporting tools. Appreciate the response though.