I found a great use for the visual Layout Tool which solved the formatting issues I was running into. Unfortunately it doesn't pass through additional columns from the source. This means that I am unable to use the batch rendering (the "group data into separate reports" functionality in the render tool). See images below.
Image 1: Layout keeps columns in output 🙂
Image 2: Visual Layout drops columns in output
Cheers