Crystal Reports

Crystal Reports allows you to create reports easily through its experts and wizards. Refer to the Crystal Reports documentation for more details. When working with Crystal Reports, be aware of the following items:

• Crystal does not support the SET command. You must use a WHERE clause in a SELECT statement to specify query parameters.
• A single Crystal 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.
• If you want to report on numeric data in the Value or Quality columns of the ihRawData table, you may want to convert all Variant to Float data types from the Report Expert, so that Crystal Reports displays them correctly in the report. This also enables the correct formatting.
  Note: See Displaying Variant Data Type Columns as Floats in Crystal Reports for more details.
• Analysis of the ihTrend and ihAlarm tables in Crystal Reports is not supported.