Frequently-asked questions about Crystal Reports.

How do I disable Auto SmartLinking?
In Crystal, go to File | Options | Database and then in the left corner un-check the “auto smart linking” box.

What is the best way to include a date/time stamp in my report?
Embed the DataDate and DataTime fields in a text object. Note: Do not use the CurrentDate and CurrentTime fields for this purpose; these fields are refreshed each time the report is viewed, regardless of whether or not the report is refreshed.

I get an error message that reads ‘Error in compliling SQL Expression : Query Engine Error: ‘HY000:[Oracle][ODBC][Ora]ORA-00936: missing expression’ when trying to save a SQL Expression. What is the problem?
Ensure that your SQL expression is enclosed in parentheses.

How do I erase all values in an array?
Set your array equal to a dimensioned, but unsized array.

' dimension an empty array
Dim Empty() as DateTime

‘ dimension desired array
Global Extubated() As DateTime

‘ erase values
Extubated=Empty

No tags