CrystalReport - Other

Check if NULL

ISNULL(var)

Measurement

  • 1 cm = 576 twips
  • 1 inch = 1440 twips

Move Object Position

x-axis/y-axis : - for left/bottom : + for right/top

PNG Picture transparent background become black

  1. Create a new Microsoft Word document and insert your picture on to the document.
  2. Go to Page > Layout and remove the margins so that it is the same size as your picture and save the document file.
  3. Go back to your report and choose Insert > OLE Object > Create From File and choose your new document file.

Replace function

REPLACE(var, selectedValue, replaceValue)

Replace space to new line

REPLACE(var, " ", ChrW(13))