Reporting Tables, Headers, and Footers

Question

Hi all- I'm having unexpected results from a report I'm trying to build.  From the attached workflow, I'm getting the following problems:

1.) Veg and Fruit is showing up in two tables each.  I was expecting one table for each grouping.

2.) The Header and Footer is repeated is time.  I just want 1 header and one footer for the whole PDF report.

I'd very much appreciate any help you could give. :)  Thanks!

Alteryx Question.yxmd

davidskaife · Accepted Answer

Hi @JGHOLLAND

You mean like this?

On the Layout tool after the Union, change the Layout Mode to All Records Combined and that should get the above - note you have blank rows in both inputs which need to be deleted as well.