Report Text- repeating in every table groupby

[mfang]

Hello, I'm trying to use report text to create a header for my excel output via the Render tool. In my table I also selected the groupby function. In my excel output the header is being repeated for each section of my tables base my how I get it to be groupby. Please help. I want 

Header:

Table 1

Table 2

but the excel output is doing this:

Header

Table1

Header

Tables2

thanks. 

[ramesh_neel]

@mfang  -  I have attached a workflow that uses a union query and got rid of the repeating header . Hope this helps 🙂

[mfang]

How can I get the data in a column to show up as an available field in the in the text layout tool. It looks like only  few is showing up. Thanks so much!

[ramesh_neel]

@mfang  - Are you using a layout tool ? and what is the tool that passes the data to the layout tool?

[mfang]

Thanks for the workflow you attached - is there a way to have the second table not to show column name? Thanks again!

[ramesh_neel · Accepted solution]

@mfang  - Hope the modified workflow helps! If you think this has helped you , can you mark the solution as accepted?