topic Re: Font lost when use excel to load a PDF file exported from Report Builder in Report Server

Font lost when use excel to load a PDF file exported from Report Builder

ThuNguyen — Fri, 20 Sep 2024 13:38:23 GMT

Hi,

I use Report builder to export to PDF and send to user, when user use Excel to load this PDF (Data - Get Data - From File - From PDF, the font does not show correctly. Data type in SQL is nvarchar font in Report Builder is Arial (the text is in Vietnamese - Unicode)

Text in Report builder (and PDF):

CÔNG TY TNHH DTG MEDICAL

CÔNG TY TNHH DỊCH VỤ NĂNG LƯỢNG GE PMTP

Text loaded in Excel:

CÔNG TY TNHH DTG MEDICAL

&Ð1*7<71++'ʇ&+9ͤ1Ă1*/Ɉ͢1**(3073

When I copy from PDF and paste here, it will be:

CÔNG TY TNHH DTG MEDICAL

􀀦􀃐􀀱􀀪􀀃􀀷􀀼􀀃􀀷􀀱􀀫􀀫􀀃􀀧􀊇􀀦􀀫􀀃􀀹􀍤􀀃􀀱􀄂􀀱􀀪􀀃􀀯􀉈􀍢􀀱􀀪􀀃􀀪􀀨􀀃􀀳􀀰􀀷􀀳

Anyone can help?

Re: Font lost when use excel to load a PDF file exported from Report Builder

hackcrr — Sat, 21 Sep 2024 04:22:47 GMT

hi, ThuNguyen

You can try using an Excel-supported font in Report Builder, such as Times New Roman or Arial Unicode MS. Arial Unicode MS is a font that contains a large number of Unicode characters, which makes it more suitable for working with multilingual text.

In addition, you may consider using third-party software specifically designed to convert PDF files, these tools may have better character encoding support.

If I have answered your question, please mark my reply as solution and kudos to this post, thank you!

Re: Font lost when use excel to load a PDF file exported from Report Builder

ThuNguyen — Wed, 25 Sep 2024 01:38:07 GMT

Hi hackcrr,

I used Arial/ Times New Roman in Report Builder. I tried to read exported PDF with Python the font still error.

Re: Font lost when use excel to load a PDF file exported from Report Builder

Anonymous — Wed, 25 Sep 2024 06:14:33 GMT

Thank you hackcrr

Hi, ThuNguyen

You need to set up your generic font in Report builder as shown in the image below:

Then export to PDF:

Get the data from this PDF in excel:

In the Power Query window that appears, format each column by your user's locale:

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Font lost when use excel to load a PDF file exported from Report Builder

ThuNguyen — Wed, 25 Sep 2024 08:58:39 GMT

Hi CST,

I set up as yours but no luck:

Font on Report Builder:

Exported PDF:

Power query:

Change Type to Local (Vietnamese or any font):

Am I missing something?

Re: Font lost when use excel to load a PDF file exported from Report Builder

Anonymous — Wed, 25 Sep 2024 09:45:08 GMT

Hi, ThuNguyen

Does the data in your database use the fonts shown in the screenshot below?

You need to remove the change type, as shown in the following figure:

Additionally, you need to install the Vietnamese language on your computer:

Here are my tests:
After I installed Vietnamese, I created some sample text in my database:

Then export to PDF from Report Builder:

Afterwards you should be able to load it correctly from Excel:

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.