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

[J-Riedel]

Hi,

I am trying to get a 5 tables to output to 3 tabs in Excel using the Render tool.  I have created my tables and added unions to get to where I need to be.  Everything is working perfectly, expect for the Header that I have added (using the Report Text Tool).  Currently, it is adding the report text to each table, even when 2 tables are on the same sheet in Excel.  Therefore, I am wondering if there is a way to only repeat the report text for each tab that it will output to Excel (Group By), rather that for each table?

Here is a view of the output.  I do not want the text in green highlighting below to be repeated since it is on the same tab in the Excel file:

Here is the configuration of my Report Text:

Here is the configuration of the Layout Tool:

[J-Riedel]

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.

[atcodedog05]

Happy to help : ) @J-Riedel 

Cheers and have a nice day!