I'm running a Workflow that is that identifies Stores and what group they are in. Is there a way, after each group moves to Excel to add the Header Line again followed by a space and then the next group and repeat and repeat? Thanks in advance for any ideas / help.
Example:
GROUP | CHAIN | NABP | STORE_NAME | ADDRESS | CITY | ST | ZIP | Phone() |
A1 | 1 | 0590554 | ABC Store | 100 Main St | CA | 91604 | (818)506-1111 | |
A1 | 5 | 3148461 | Some Random Store | 200 Someplace St | NJ | 07114 | (862)276-2222 | |
A1 | 7 | 4444725 | Store Name Something | 3163 S CHURCH ST | TN | 37127 | (615)225-3333 | |
GROUP | CHAIN | NABP | PHARMACY_NAME | ADDRESS | CITY | ST | ZIP | Phone() |
B4 | 12 | 0590554 | STUDIO PHARMACY | 5 South St | CA | 91604 | (818)506-5555 | |
B4 | 8 | 3148461 | 709 ACE PHARMACY | 10 Another St | NJ | 07114 | (862)276-2222 | |
B4 | 6 | 4444725 | LIFEPOINT PHARMACY | 15 Maple St | TN | 37127 | (615)225-1111 |
Solved! Go to Solution.
Hi!
Yes, with the Table and Render tools, it's easy.
In the table tool, you would set a grouping level at the top, and you'd choose "Group" in your example below. This creates separate tables, complete with headings, for each group level.
Then you'd add a Render tool. In that tool, configure the report to add whitespace between groups. Here's a snapshot of the render tool