Solved

C# - Crystal Reports - MICR  Font

Posted on 2014-04-05
13
461 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Nice table. Huge mess. Maybe this was something you created way back before you figured out tabs or a document you received from someone else. Either way, using the spacebar to separate the columns resulted in a mess. Trying to convert text to t…
Microsoft Word is a program we have all encountered at some point, but very few of us have dug deep into its full scope of features, let alone customized it to suit our needs. Luckily making the ribbon (aka toolbar, first introduced in Word 2007) wo…
This video walks the viewer through the process of creating a watermark for their document, customizing it, and saving it for viewing/printing needs.
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.

726 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