Render 4 layouts into 1 excel sheet with Dynamic File Name

[Jason_Gan_565]

Hi, I am trying to render 4 layouts into 1 excel sheet where I would like to dynamically append table fields into the file name. 

To solve the Dynamic File Name, I have to use "Group Data Into Separate Reports" but doing so, my output file would generate 4 separate sheets for the respective layouts. 

Any way to resolve this? 

Thank you in advance

[Jason_Gan_565]

Please see attached images for reference 

[KimLamNg · Accepted solution]

@Jason_Gan_565 You can try adding a Layout tool before the Render tool and select Each group of Records for Layout Mode and Group by "FilePath with Sheet name". Then uncheck the box Group Data info... in the Render tool because you will have only one record now.

[Jason_Gan_565]

@KimLamNg, thanks! it worked!