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!

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
SOLVED

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

sanjdhar
7 - Meteor

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

 

2 REPLIES 2
jamielaird
14 - Magnetar

Hi @sanjdhar 

 

I suspect that the full cost centre value is being passed into the table but the column width is causing it to truncate.

 

To better troubleshoot the issue you could try adding a Select tool before your table tool and removing all columns except the cost centre column. This will show whether the number of columns is the issue.

 

If it is, then you will need to reduce the number of columns or table layout options in order to make the data fit without truncating.

sanjdhar
7 - Meteor

Thanks.

 

Someone else raised a similar issue here:

 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Savings-app-output-to-Excel-truncates-...

 

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.