Header and Footer won't render with report render tool in browser

[ccagle]

Hey Everyone, 

I'm trying to use the header and footer tools with the report render in Alteryx gallery. I currently have both tools setup before the render tool and after the table tool. Note that data returns in this workflow via the table + render tools (in the browser). 

None of the header and footer information is rendering in the browser on the gallery. Am I doing something wrong here? Let me know if more info is needed - the picture of the workflow and render tool configuration should be pretty clear as to what is going on. 

[AndrewS · Accepted solution]

Hi @ccagle 

Try running your reporting tools into a Join Multiple prior to the Layout - I've attached a crude example.

[ccagle]

Thanks Andrew, I actually got it working with just the layout tool and didn't need the join tool. Not sure why the layout tool is needed, but that definitely works so thanks for the help!

[jvaucher0804]

Hi there!

I'm trying to add a header and footer on each of my excel tabs. I've added a header and footer tool before my render tool and getting this error: 

Thoughts?