Crystal report Failed to retrieve data from the database.

Version 2
    Question

    Crystal report i.e. Incident.rpt runs ok in Crystal XI but when run from Console using print button gets message Failed to retrieve data from the database. Details: Database Vendor Code:102.

    Answer

    If you are using SQL expression fields in the report, edit the SQL expression and make sure the the whole expression is surrounded by round brackets i.e. (sql expression)

    Environment

    Crystal XI  ITBM 7.2