Converting the IhRawData Value Column From Variant to Float

Procedure

  1. After you have added the Historian OLE DB Provider database connection and added Historian database tables, select the Fields tab in the Standard Report Expert.
    The following figure shows how the Fields tab should appear.
    Figure: Fields Tab in Standard Report Expert
  2. Click the Formula button.
    The Formula Name dialog box appears.
  3. Enter a name.
    You can enter any name that you want.
    The Formula Editor appears.
    Note: You can also access the Formula Editor by selecting Field Object from the Insert menu. This opens the Field Explorer. Right-click the formula fields and select New from the pop-up menu.
  4. Enter the following text in the Formula field:
    ifnumerictext({ihRawData.Value}) then cdbl({ihRawData.Value}) else 0
    The Formula Editor should look similar to the following figure.
    Figure: Crystal Reports Formula Editor
  5. Click the Save button.
  6. Use the formula as a normal numeric column instead of the Value column in the report.