Multiple snippets on multiple excel tabs via render tool
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have a workflow which summarises output by month and by time.
For each, there is a graph and a table giving me four report snippets in total.
I want to render these to Excel with two tabs.
I can get all snippets on one tab, or I can get each snippet on its own seperate tab.
Is it possible to have two snippets (a graph and a table) on two tabs?
(I hope that makes sense? )
Solved! Go to Solution.
- Labels:
- Common Use Cases
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
BTW it always seems to order the tabs alphabetically, the only way around this I've found is to number my tabs in the order I want them, so each tab name is of the form "1. name of tab", "2. name of next tab", ... , "N. name of nth tab"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Phil, your example would be helpful. I had given my groups meaningful names in the formula tool and I've checked everything I could in the last layout tool but my excel tabs just show the default naming. Thanks for the quick response.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I'll get on it first thing in the morning
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
So simple, my mistake was each formula tool group column header was called something else, now they are all "Group" and it works like a charm, Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Glad I could help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
If you add a layout tool, you should be able to reorder the Excel tabs from your snippet in the "Per Row Configuration" section located on the bottom left of the configuration, using the up-down arrows. If your layout tool mode is Each Individual Record, Orientation, Vertical With Section Breaks, you can select these items individually, in this same box and name them in the "Section Name" box that appears.
I wish I could paste snippets in here. I'd show you. Too busy to save a snippet and insert it. But if you need more explanation, you can email me and I'll paste the snippets in email and send to you.
![](/skins/images/5A278AAD67B5F68761E04A0A1AFFBB3D/responsive_peak/images/icon_anonymous_message.png)
- « Previous
-
- 1
- 2
- Next »