Reporting Tables, Headers, and Footers

[JGHOLLAND]

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!

[davidskaife · Accepted solution]

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.

[JGHOLLAND]

@davidskaife   Thank you very much!  It worked great. 😁