Font Issue when converting Reports from Crystal to Bi PUblisher

Brock
Brock used Ask the Experts™
on
Hello,

I am converting Crystal Reports to BI Publisher.  BI Publisher uses MS Word for the visual display.  I am extremely inept at look and feel.  Attached you will find 2 samples of text. The crystal uses Arial 8 for these labels.  When I use Arial 8, in word it does not display the same amount of text.  

What font would you suggest to get the same look and quantity of letters in .

Thanks in advance,

Brock
BI-PUBLISHER-FONT.PNG
Crystal-Font.PNG
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
Do you have the same printer driver selected in both instances?

Are the margins set the same?

mlmcc
C. Blaise MitsutamaLMS Administrator | Instructional Designer

Commented:
Hi, Brock,

The characteristics of fonts depend on a number of factors, including printer drivers and font type (True Type Fonts, True Type Collection, Printer Font Metrics, Adobe Font Metrics, Printer Font Binary, Printer Font ASCII, raster, vector, or OpenType). As you've noticed, the appearance and spacing of the same font at the same size may vary in different software, on different brands of computer, or in different versions of the software, device drivers, and operating systems.

The solution isn't necessarily to try to find a different font. When I've needed to conform the way that type fits on a page, a certain amount of trial-and-error is required. I modify the horizontal and vertical spacing parameters for individual characters and between "words" using Advanced Character Spacing features.  As you're probably aware, in Microsoft Word, these features are controlled in the Font group and the Paragraph group on the Home tab.
Screenshot of the Font Window -> Advanced Tab, which shows the Character Spacing options.
Also, keep in mind that even if you get the content to fit on your system, if you transfer the content to a different computer setup, it's possible that the appearance of the data may change. Actually, the PDF format was developed to provide consistent document formatting across platforms, software, and  hardware due to these potential disparities.

Here are some resources that may help:

Commented:
Irrespective of which font type you use, Crystal Reports displays the font with a reduced size of 0.5 when MS Word or RTF is used as an exporting option.

There is a resolution provided by SAP itself in the below link where in, you are suppose to make changes at registry level. You need to take extra caution while making changes on registry as the wrong change would corrupt the registry file. It's always suggested to take a backup of registry file in case you want to restore it back.

One more point to note is, the change suggested is applicable for Crystal Reports 2008, 2011, 2013 and 2016 versions only.

Follow this link and follow the steps carefully on your local machine first.

https://apps.support.sap.com/sap/support/knowledge/public/en/1810847

Hope that helps.
Amazon Web Services

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
Are you comparing the Word report from BI Publisher to the Crystal Report in the viewer?
If so the export hack mentioned above does not apply.

If you are exporting to Word from Crystal then try reducing the font in BI publisher to 7.5

mlmcc

Author

Commented:
Thank you, All.  Sorry I was away on vacation.

I will take into consideration what you have said as I work  on the BI Word Template today.

Brock.

Author

Commented:
Thanks to all.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial