Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Character encoding, text alignment, page layout, and print issues with regard to Reporting

45179902
8 - Asteroid

I have an Excel file with rows of data. For each row, I need to export a PDF letter. All the letters generated from this Excel should be combined in one PDF document (page 1 is letter for row 1, page 2 is letter for row 2, so on and so forth.)

 

I encountered the following issues, and I'm looking for solutions:

 

1) Character encoding: The letters are provided in two languages: English (GB) and Chinese (HK). Whilst English texts could be printed successfully, Traditional Chinese characters are not readable as shown below. Is there a way to adjust character encoding in Alteryx? My other PDFs with Traditional Chinese characters work fine (UTF-8, zh-hant, Big5).

GeorgeL_1-1643168909444.png

 

2) Text alignment: I'm looking to justify the text. I believe Report Text only has centre, left and right alignments. How do I achieve this (PCXML coding perhaps?)

 

3) Page layout: I find Alteryx reporting tools still need significant improvement for better report formatting. How do I ensure that pages are divided correctly in Report Text tool? For example, how do I ensure that Page 1 content stays on Page 1 and Page 2 content stays on Page 2?

 

4) Export to one PDF: How do I export all PDF letters combined? I know the Layout tool has an option for combining records, but for the sake of this project, I must use Visual Layout. How do I do this?

 

 

 

0 REPLIES 0
Labels