Crystal Report: Convert Amount to Words

Report Application: Crystal Report Version: 2013 Scenario: I have a field {ARIBH.AMTNETTOT} that has amount in figures and the client needs the amounts in words Solutions //extract Naira¬† only Propercase(ToWords(truncate({ARIBH.AMTNETTOT}),0) + ‘ Naira and ‘ + //extract the Kobo and convert to words Another formula for rounding up. ToWords(remainder({ARIBH.AMTNETTOT}*100,100),0) + ‘ Kobo Only.’)   Do […]

Continue reading