App output in pcxml shows different than Excel, Word, PDF report formats in Server

sanjdhar

Hi there,

I have a workflow (pictured below - Attachment #1) which outputs to a Render Report in pcxml format. I have published this to my company's local gallery and run it as an analytical app. 

The pcxml output shows the Cost Center (first field) as I expected it to be (see attachment #2).

However, when I click on the xlsx report format presented in the  Gallery, the output has the cost center field truncated with the last 2 digits missing (attachment #3).

Any way to fix this? I have defined the Cost Center field as string type. 

Thanks

cost center 1.png

cost center 2.xlsx

Cost Center Lookup.png

sanjdhar

Thanks.

Someone else raised a similar issue here:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Savings-app-output-to-Excel-truncates-data/m-p/67169?collapse_discussion=true&q=pcxml%20vs%20Excel&search_type=thread

I changed the Render report tool Report Style to Custom Size, increased the size (in.) to a 16" (from the standard 8.5"), and that removed the truncation issue in xlsx, pdf, and doc output formats.

I will mark this issue as solved.