Report Text - Repeating for Each Table instead of Each Group By (Excel Sheetname)

I mocked up a workflow to took into and understand the issue. You need to add another layout tool after report text tool and mention section name. It seems to work after that.

Workflow:

Hope this helps : )

report tables.yxmd

report.xlsx

All comments

Configure the report text tool to attach on top after layout tool. It should do the trick.

Hope this helps : )

This solution works, with the exception of the report tool content. I was adding the report date dynamically to the report text. To do this, after the last union, I added a Formula Tool to calculate the last day of the prior month and output to a new field. Once I added this, the Date would show up in my "Available Fields" listing in the Report Text Tool. If I move the Report Text Tool to after the Layout, I loose the date as an available field. Do you know why and how could I get that back so that I can continue to dynamically add the date to the header?

Thanks!

Happy to help : ) @J-Riedel

If my response helps please don't forget to mark it as solution.

Cheers and have a nice day!

I ran into an issue. If I do the suggestion you gave, it moves my output to Excel from 3 tabs to only 1. I need them on different tabs. Suggestions?

Was sheetname also selected as you have done above. Select Sheetname and dates and mention section name has you had done before.

I have the selections that you have mentioned above and it still only renders the output into one tab in Excel. Do I need to o anything different in the Render Configuration?

Here is my Layout Configuration.

Render Configuration:

I mocked up a workflow to took into and understand the issue. You need to add another layout tool after report text tool and mention section name. It seems to work after that.

Workflow:

Hope this helps : )

report tables.yxmd

report.xlsx

ok, this time it worked like a charm. Thank you so much for the help! This community is great for the help and fast responses!

Have a great afternoon.