Render 4 layouts into 1 excel sheet with Dynamic File Name

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

Reporting

Output

Accepted answers

KimLamNg

@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.

All comments

Jason_Gan_565

Please see attached images for reference

KimLamNg

Jason_Gan_565

@KimLamNg, thanks! it worked!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703