Crystal Reports

Crystal Reports allows you to create reports easily through its experts and wizards. When working with Crystal Reports,remember that:

  • Crystal does not support the SET command. You must use a WHERE clause in a SELECT statement to specify query parameters.
  • A single report can only retrieve data from one server, but you can create subreports from different servers within a report.
  • The Crystal Reports application does not display milliseconds in timestamps.
  • IIf you want to create a report on numeric data in the Value or Quality column in the ihRawData table, you may want to convert all Variant data types to Float data types so that Crystal displays them correctly in the report. Refer to Format Decimal Point Precision for instructions.
  • Analysis of the ihTrend and ihAlarm tables in Crystal Reports is not supported.
Table 1. Crystal Reports Samples
File Name Description
SimpleCrystal80Report.rpt Contains values cast from Variant to Float.
MultipleServersSubreport.rpt Contains data from two servers by using a subreport.
iFIX1_CHART_OLEDB.rpt Contains data from iFIX Sample System converted from the iFIX Historical ODBC driver to OLE DB.
iFIX1_CROSSTAB_OLEDB.rpt Contains data from iFIX Sample System converted from the iFIX Historical ODBC driver to OLE DB.
iFIX1_DAILY_OLEDB.rpt Contains data from iFIX Sample System converted from the iFIX Historical ODBC driver to OLE DB.