We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Reporting tools - Repeat Headers

suwenchuan
7 - Meteor

Hi Alteryx community, appreciate if anyone could provide some guidance here.

 

Issue:
When my table spans multiple pages, the column headers don't repeat on new pages.

This makes the report hard to read as users need to scroll back to see what each column represents.

 

What I've tried:
1. Looked through Table tool settings - couldn't find header repeat options
2. Checked Layout and Render tool configurations - no obvious settings for this
3. Attempted to break data into smaller tables with fixed number of rows - didn't work well because:
- Rows have variable heights
- Results in either page overflow or wasted space
- Not a dynamic solution

 

Question:
Is there a way to make table headers repeat on new pages using these standard reporting tools?

If not, what alternatives would you recommend?

 

Environment:
- Alteryx Version: 2023.2
- Output Format: Word document (.docx)

 

Attached a sample workflow. In this example, Key 3 spans across two pages.

 

Thanks everyone!

1 REPLY 1
DavidP
17 - Castor
17 - Castor

Hi @suwenchuan 

 

I'm thinking you can do something like this. Create a Table that only has the column names and use it as the Header in your Render tool. Remember to uncheck "Show Column Headings" in your original table tool.

 

It's not pretty, but it works. You'll have to play around with fixing the alignment.

 

column names as header.png
 
Labels
Top Solution Authors