?
Solved

C# - Crystal Reports - MICR  Font

Posted on 2014-04-05
13
Medium Priority
?
489 Views
Last Modified: 2014-04-12
I have an application that produces checks.  It utilizes Crystal Reports and then saves it as a word document.  The MICR font is not displaying correctly.  I am using the E-13 font in crystal and it is also installed on the computer.

Any idea why its not displaying correctly?
0
Comment
Question by:CipherIS
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 5
13 Comments
 
LVL 6

Expert Comment

by:Patrick Tallarico
ID: 39980923
Not sure if this will help but it sounds like it may be similar to what you are going through.
The last post appears to have a possible solution.  In this case it looks like it was actually the driver for the printer.
http://scn.sap.com/thread/2153768
0
 
LVL 1

Author Comment

by:CipherIS
ID: 39983557
I narrowed down the issue.  On Crystal Reports I am selecting "E-13" which displays "E-13B" but when it exports to word its picking "13B" not "E-13B" which does exist in word.  If I change it to "E-13B" manually it is correct.

Any idea why its trying to pick "13B" and not "E-13B"?  Any idea how to resolve?
MicrFont01.jpg
MicrFont02.jpg
0
 
LVL 1

Author Comment

by:CipherIS
ID: 39983633
Is there a way to perform a search and replace of a Font via Microsoft.Office.Interop?
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 6

Expert Comment

by:Patrick Tallarico
ID: 39983723
Is the don't size changing also?  There are a few articles out there about this same behavior with various other fonts and pdf docs. In some cases it is related to a known issue, and there is a patch or gothic for it. In others it is actually a result of a particular font having a specific size that serves as a 'native' size for the font. In the export process when the font is processed in any size other than it's 'native' size, Microsoft products especially seem to convert the font to another.
Two things I would be curious about would be if changing the font size affects this behavior. The second would be if this also happens during a different type of export like.erg or .pdf, but I realize that since this is a result of code, it may a bit time consuming to write a but of code like that just for testing.
0
 
LVL 1

Author Comment

by:CipherIS
ID: 39983727
The PDF is created correctly.  I had the application export the PDF before it exports to word to see what its doing.

The problem is when it exports to word, word is setting that line to "13B" and not "E-13B".
0
 
LVL 6

Expert Comment

by:Patrick Tallarico
ID: 39983736
Is the font size 14pt?
0
 
LVL 1

Author Comment

by:CipherIS
ID: 39983761
no, its 12.
0
 
LVL 6

Expert Comment

by:Patrick Tallarico
ID: 39983775
It seems as though the size of the font may matter depending upon the vendor of the font. There should be recommendations as to the appropriate font size to use with the font that you have that may help resolve some of these types of issues.  I've seen a few at 14, others at 10. How did you acquire the MICR font, was it with another bundle of software, or a direct purchase of the font?
0
 
LVL 1

Author Comment

by:CipherIS
ID: 39983797
Purchase of font and like i said, it prints fine when Crystal exports to PDF.  When it exports to word it is picking "13B" font instead of "E-13B" font.  If I manually change the font in Word it is correct but I need this to work programmatically.
0
 
LVL 6

Expert Comment

by:Patrick Tallarico
ID: 39983830
As I understand it this font size issue happens much more frequently with the ms office products than when exporting to pdf. Do you know if the font package recommends a size? Even if the font is a true type font there have been occurrences of this behavior with don't size and exporting to office.
0
 
LVL 1

Author Comment

by:CipherIS
ID: 39983839
Its 12.
0
 
LVL 1

Accepted Solution

by:
CipherIS earned 0 total points
ID: 39984255
0
 
LVL 1

Author Closing Comment

by:CipherIS
ID: 39995870
Had to perform a find and replace in MS Word.
0

Featured Post

Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
The viewer will learn how to make their project stand out over others by learning how to change colors and shapes, add spaces, change directions, and add bullets to their charts.
Office 365 is currently available in five editions. Three of them are for business use: Office 365 Business Essentials, Office 365 Business, and Office 365 Business Premium. Two of them are for home/personal use: Office 365 Home and Office 365 Perso…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question