Alteryx Server Discussions

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

Generating PDF with Bold Font

maxksoll
7 - Meteor

Hi all,

 

I am faced by a very strange problem regarding the generation of PDF files. The main idea is to format a PDF a little more user friendly. The Designer returns the results as they should look, but when I tested the same on the server all bold fonts are gone.

 

As a test I created a simple workflow (as attached) which produces three lines of text:

maxksoll_0-1605015782859.png

 

Looks fine produced by the designer, but from the server it looks different:

maxksoll_1-1605015822903.png

Currently I am running the version 2020.2 on Designer and server.

 

Did someone experienced something similar or even found a solution?

 

I hope it's just a configuration problem from my side.

 

Thanks in advance and best regards

Max

11 REPLIES 11
Amarendra
10 - Fireball

Bold font should be supported I believe on the server since it is not a custom font.
Can you try using HTML tags? Something like Replace([Your field],[Text that you want in bold],"<b>" + [Text you want in bold] + "</b>")

maxksoll
7 - Meteor

Thanks for your suggestion, but unluckily it still doesn't work.

 

Designer works fine but server does not.

 

Attached you can find my adjusted workflow.

seinchyiwoo
Alteryx Alumni (Retired)

Hi,

 

You will need to use Report Text and select "Treat text as Raw PCXML".

You either format it using a formula or directly in Report Text > Text Data section.

seinchyiwoo_0-1605079017161.png

 

This is how the output looks like:

seinchyiwoo_1-1605079042581.png

 

Workflow attached.

 

Best,

Seinchyi

maxksoll
7 - Meteor

Hi,

 

thanks for your answer, but unluckily it still does not produced the expected output on the server for me.

 

@seinchyiwoo: Did you execute it on the server?

 

Best regards

Max

seinchyiwoo
Alteryx Alumni (Retired)

Hey Max,

 

Yes I did and it worked.

Try the attached workflow and see if it works on your side as well.

 

What I'm seeing in the PDF after executing the workflow:

seinchyiwoo_0-1605151124725.png

What I have done in the Report Text tool: 

seinchyiwoo_1-1605151215680.png

 

 

Alternatively you can also try render it as PCXML which will also give you the options to download the output as pdf. 

maxksoll
7 - Meteor

Hi,

 

thanks for the attached workflow. It also produced a similar result as the tests before:

maxksoll_0-1605172116018.png

 

I guess there should be a problem with the fonts on the server, but I am not sure how this could be solved ..

 

Best regards

Max

 

maxksoll
7 - Meteor

Turns out there is a problem with accessing the font on the server:

maxksoll_0-1605175545098.png

 

The Run-As account seams to have all required permissions, but it still fails.

 

Did anyone faced such a problem before?

 

Best regards

Max

seinchyiwoo
Alteryx Alumni (Retired)

Ah that's interesting. I suspect the font style "Bold" is not available for Arial font type on your Alteryx Server...

Do you want to do a quick check at your server OS and see if there is any font that comes with "Bold" style?

seinchyiwoo_0-1605176823404.png

 

Try it with the font that comes with Bold style and see if it works for that font type.

 

If that's really the case - check out here to see how you can install fonts in Window: https://support.microsoft.com/en-us/windows/how-to-install-or-remove-a-font-in-windows-f12d0657-2fc8... 

 

Cheers,

Seinchyi

maxksoll
7 - Meteor

Unluckily I already did this check and the server has the font available. It also works in other applications on this machine.

 

Also the Service Account which is Hosting the Alteryx Server is granted for all the fonts.

 

Is there some other thing I could check on what could lead to this issue? I am out of ideas right now ...

 

Thanks in advance and best regards

Max