Skip to main content
Back to path

Welcome to a Grasp lesson

Create a free account to keep studying and create your own study path.

Lesson 71

Enhancing Reports with Headers and Footers

Recommended resources

Introduction

Welcome back! In our previous lesson, you learned how to assemble the core body of a report by combining various reporting snippets—like tables and charts—using the Union and Layout tools. You now have the skills to create a structured page layout.

However, a professional report needs more than just a well-arranged body; it requires context. This includes elements like a main title, the date the report was generated, a company logo, page numbers, and confidentiality notices. This is where today's lesson comes in. We will focus on adding these crucial finishing touches to your reports.

Our learning outcome for this lesson is to add context to reports using the Report Header and Report Footer tools. You will learn how to configure these tools to add professional, consistent branding and metadata to your reports, a key skill for creating polished, shareable outputs in Alteryx.

1. The Role and Placement of Header and Footer Tools

In Alteryx, the Report Header and Report Footer tools are dedicated to adding information to the top and bottom margins of your final report.

  • Report Header: Typically used for a report title, a company logo, and the date of creation.
  • Report Footer: Generally contains page numbers, copyright information, or confidentiality disclaimers.

A crucial concept to grasp is their placement in the workflow. Unlike a Report Text tool, which creates a snippet that becomes part of the report body (and is fed into a Layout tool), the Header and Footer tools are applied after the body has been fully assembled.

The typical reporting workflow looks like this:

  1. Create individual reporting snippets (tables, charts, text, maps).
  2. Combine them into a single stream using a Union tool.
  3. Arrange the snippets using a Layout tool.
  4. Connect the Report Header tool to the output of the Layout tool.
  5. Connect the Report Footer tool to the output of the Report Header tool.
  6. Connect a Render tool to finalize the output (which we will cover in the next lesson).
Alteryx Workflow with Report Header and Footer Tools
This workflow illustrates the standard sequence. Notice how the Report Header and Report Footer tools are chained together after the main report element (the Interactive Chart) has been created.

For a simple, visual walkthrough of this process, the following guide is very helpful.

Header and Footer - Alteryx: Creating a report

Please read this guide from Baylor University. It provides a clear, step-by-step overview of adding and connecting the Report Header and Footer tools in a workflow.

Read the entire 'Creating Headers and Footers' section. Pay close attention to the screenshots that show how the Report Header tool is connected to the previous reporting tool, and how the Report Footer tool is then connected to the Report Header tool.

2. Configuring the Report Header Tool

The Report Header tool provides several options for adding dynamic and static content to the top of your report. Let's explore its configuration panel in detail.

Report Header Tool - Alteryx Help

The official Alteryx documentation offers a comprehensive look at all the configuration options for the Report Header tool. This will help you master its features.

Read the section titled 'Configure the Tool.' Focus on understanding the three main configuration areas: 'Report Title,' 'Report Date,' and 'Report Image.' Note the extensive formatting options available for the date.

Based on the documentation, here are the key settings:

  • Report Title: A simple text field where you can enter the main title for your report (e.g., "Q3 Sales Performance").
  • Report Date: By checking "Include the date in your report header," you can automatically add the timestamp of when the report was run. This is invaluable for version control. You have granular control over the language and format (e.g., MM/dd/yyyy vs. Month dd, yyyy).
  • Report Image: This allows you to add a logo. You can use the default Alteryx logo or specify a path to a custom image file (e.g., your company's logo). Be mindful of the note on image size to avoid layout issues.

3. Configuring the Report Footer Tool

The Report Footer tool is configured in a similar way to the Header tool but is focused on content for the bottom margin of the report. Its configuration panel includes:

  • Copyright Text: A text field for adding static text. This is the ideal place for copyright notices (e.g., "© 2024 Your Company"), confidentiality statements ("For Internal Use Only"), or the report's author.
  • Page Numbering: This is one of the most important features of the Footer tool. You can choose from several formats, such as:
    • Page # (e.g., "Page 1", "Page 2")
    • Page # of ## (e.g., "Page 1 of 5", "Page 2 of 5")
      This is essential for multi-page reports to ensure readers can navigate them correctly.
  • "Do not include a horizontal line in the footer": A checkbox that allows you to remove the default separator line above the footer text for a cleaner look.

Together, these two tools frame your report content, giving it a professional and complete feel.

4. Hands-On Practice

Now it's time to apply what you've learned. We will extend the workflow you built in the previous lesson's practice exercise. If you don't have it saved, you can quickly recreate the first four steps.

Starting Point:
Your workflow should have a Text Input tool with sample sales data, streams for a Report Text title, a Table, and an Interactive Chart, all combined with a Union tool and arranged with a Layout tool.

Alteryx Reporting Workflow with Header and Footer Tools
Your starting workflow should look something like this, with various reporting elements combined before the final rendering steps.

Your Task:

  1. Locate the output of your Layout tool.
  2. Add a Report Header tool from the Reporting palette and connect it to the Layout tool's output.
  3. Configure the Report Header tool as follows:
    • Report Title: Quarterly Sales Analysis
    • Check "Include the date in your report header" and select the format Month dd, yyyy.
    • Check "Include an image (logo) in your header" and leave the default "Use the Alteryx Logo" selected.
  4. Now, add a Report Footer tool and connect it to the output of your Report Header tool.
  5. Configure the Report Footer tool:
    • Copyright Text: Confidential: For Internal Use Only
    • In the Page Numbering dropdown, select Page # of ##.
  6. Finally, add a Browse tool to the output of the Report Footer tool and run the workflow.
  7. In the Browse results window, click on the "Report" field. You should now see your composed report from the last lesson, but with a professional header (title, date, logo) and footer (confidentiality text, page numbers) framing the content.

This exercise solidifies the placement and configuration of these essential tools, completing the structure of your report.

Conclusion

In this lesson, you've learned how to add the professional finishing touches that transform a collection of data visualizations into a formal report. The Report Header and Report Footer tools provide the critical context that every report needs.

Key Takeaways:

  • The Report Header and Report Footer tools are used to add consistent information to the top and bottom of every page in a report.
  • They are placed in the workflow after the main report body has been assembled by the Layout tool.
  • The Report Header tool is ideal for titles, dynamic dates, and logos.
  • The Report Footer tool is essential for disclaimers and, most importantly, automatic page numbering.

Preview of the Next Lesson:
Your report is now fully designed and assembled, from the individual snippets to the overall layout, header, and footer. The final step is to save it as a file that can be shared. In our next lesson, we will master the Render tool, which takes your final report snippet and writes it to a variety of formats, including PDF, XLSX, and DOCX.