Solved

C# - Crystal Reports - MICR  Font

Posted on 2014-04-05
13
471 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
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 
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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…

696 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