SOLVED
Render 4 layouts into 1 excel sheet with Dynamic File Name
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Jason_Gan_565
5 - Atom
‎03-19-2023
03:36 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
3 REPLIES 3
‎03-19-2023
03:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Please see attached images for reference
KimLamNg
8 - Asteroid
‎03-19-2023
05:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
‎03-19-2023
06:10 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@KimLamNg, thanks! it worked!
