SAP Knowledge Base Article - Public

1456455 - How to convert decimal number to fraction in Crystal Reports

Symptom

Unable to convert decimal number to fraction like 1.5 as 1 1/2, 0.75 as 3/4... in Crystal Reports

Environment

Crystal Reports XI, XIR2, 2008

Cause

Function unavailable in Crystal

Resolution

  1. This function can be downloaded from
  2. https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/bobj_download/main.htm 
  3. Select Crystal Reports under software product, * under product version, Others under software type and click on search and download UFLMath.exe 
  4. Extract the file on your machine and copy the dll CRUFLMath.dll and place it in the path 
  5. for CR2008: C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32_x86
  6. for CRXIR2: C:\Program Files\Business Objects\Common\3.5\bin
  7. After placing the dll you need to register it by going to start-->run--> type regsvr32 "C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32_x86\CRUFLMath.dll"
  8. and click on OK. 
  9. Now open crystal reports application and go to formula editor you will find the newly added functions under additional functions.

Keywords

decimal to fraction, fraction, number to fraction, math function , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

Crystal Reports 2008 V0 ; Crystal Reports 2008 V1 ; SAP Crystal Reports XI ; SAP Crystal Reports XI R2

Attachments

UFLMath.zip