I am a novice at Crystal Reports. I have billing software that utilizes Access/SQL as it's database back end. I am attempting to build a report in Crystal Reports from that Access (which will be later converted to SQL) database.
My problem comes with the Memo field. When the user enters data into the Memo field, they have the choice as to which font they use as well as utilizing formatting such as underlines, bold and the like. I created my report to use a specific font for all fields - including the Memo field. However, when I generate that report, the MEMO field appears as the USER entered it...with all the formatting.
I tried to change the "Text Interpretation" box in Crystal Reports from "RTF" to "NONE", and it returned the following example:
\viewkind4\uc1\pard\fs20 Verify Glickenhaus wire deposit, make online bill payments, prepare check run, make 2010 folders, create cash activity reports, box up old files\par
I did notice that there is a formula workshop button next to the Text Interpretation button...is there a formula I can apply that will force the memo field to use the font I chose for the report - not the one the user chose in the application?
I hope that made sense?