Solved

C# - Crystal Reports - MICR  Font

Posted on 2014-04-05
13
448 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
  • 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
 
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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Need a complete list of ASP.NET page load events 3 28
Help with Word VBA class module 4 38
Not showing JavaScript in the list 5 40
Help with C#, MVC, razor. 6 23
This article describes how to use the Send to Mail Recipient command. The instructions apply generally to Office 2007 and later versions, but Microsoft® Word 2013 was used for the specific steps and figures.  What is Send to Mail Recipient? Send…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
This video teaches the viewer how to align pictures around text while keeping the text properly aligned in the document.
This Micro Tutorial well show you how to find and replace special characters in Microsoft Word. This is similar to carriage returns to convert columns of values from Microsoft Excel into comma separated lists.

867 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now