Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Tool Mastery

Explore a diverse compilation of articles that take an in-depth look at Designer tools.
Become a Tool Master

Learn how you can share your expertise with the Community

LEARN MORE

Tool Mastery | Report Text

MattD
Alteryx Alumni (Retired)
Created

Report Text.png

This article is part of the Tool Mastery Series, a compilation of Knowledge Base contributions to introduce diverse working examples for Designer Tools. Here we’ll delve into uses of the Report Text Tool on our way to mastering the Alteryx Designer:

With all the bells and whistles to play around with in the Reporting Tool Category, it’s hard not to leave some out of your reporting workflows every now and again. Just don’t forget about the Report Text Tool – the tool that’ll help you painlessly add text to your reporting objects, presentations, or documents to help spruce up their readability or formatting.

Left out.gif

What about the Report Text Tool?

Use the Report Text Tool for:

Adding titles and other descriptors to reporting elements.jpg

  • Dynamically updating reporting text (attached in Report Text.yxmd)

Dynamically updating reporting text.jpg

This use of the Report Text Tool is especially handy when it comes to automating emails (master the technique here) with customized body text or reports for individual audiences!

Including web links in reports.png

Specifying page numbers.jpg

By now, you should have expert-level proficiency with the Report Text Tool! If you can think of a use case we left out, feel free to use the comments section below! Consider yourself a Tool Master already? Let us know atcommunity@alteryx.com if you’d like your creative tool uses to be featured in the Tool Mastery Series.

Stay tuned with our latest posts every #ToolTuesdayby following @alteryxon Twitter! If you want to master all the Designer tools, consider subscribingfor email notifications.

Attachments
Comments
nishanttayal
6 - Meteoroid

@MattD 

Thank you for this great article.

I was just wondering if there any way to take the dynamic input of formatted text in this tool?

I have an application which sends a report via email and I would like to give the flexibility to end user to change the email body in RTF.

Fz
8 - Asteroid

Hello ,

 

Thank you for this article.

 

I am using the option of available field in" report text".  I have the data from the previous connected tool (select) . if I don't rename the column; I get as posting the name of column and not the data that contains but if I rename the column the tool work.

Any explication please ? 

 

Thank you !

KGS
8 - Asteroid

Hi,

 

Thanks for the article.  Is there any difference between [Region] and [Region:A].  What is the functionality of :A in the Report text tool.

 

Regards

 

G

 

mouna_belaid
8 - Asteroid

Hi,

 

Thank you for sharing this great article. I'm also wondering what the A mentionned next to Region refers to in the Report text tool.

 

Best Regards,

Sentic
5 - Atom

@MattD thanks for the article. Just as @nishanttayal I was wondering whether it is possible to have some kind of template text as input, where the template text has some basis formatting (primarily some line breaks).

 

I have this working based on template text in Excel, however when adding the text to the Text Tool the line break information is removed and you just get all text as a string (so no line breaks). Any thoughts how this could be done? Would like to avoid adding the template text directly to all Text Tools.

 

Thanks

 

Update: got it working with the help of Patricks posting in this question: Working with (wanted) line breaks and the Table > Email tools