[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

C# - Crystal Reports - MICR  Font

Posted on 2014-04-05
13
Medium Priority
?
527 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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
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

Preface: When I started this series, I used the term CommandBars because that is the Office Object class that it discusses. Unfortunately, when Microsoft introduced Office 2007, they replaced the standard Commandbar menus with "The Ribbon" and rem…
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…
In this video, we show how to convert an image-only PDF file into a PDF Searchable Image file, that is, a file with both the image (typically from scanning) and text, which is created in an automated fashion with Optical Character Recognition (OCR) …
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

830 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