I have a report I inherited that was created in Crystal. The database this report attaches to has been updated from a SQL2000 DB to a SQL2008R2 DB. I can attach to the new DB just fine to make the change within the Crystal Report. So it now is looking at the proper DB and swap it to OLE SQL from ODBC connection. however I am unable to actually pull any data using the report. There is an "AND" statement in the WHERE portion of it that shows a field :
po_purchase_order_line.date_marked_as_deleted = null
I cannot find this field referenced in the report anywhere to either remove it or update it to "is null" If I copy paste the SQL Statement into a query of the databse it won't run unless I either remove the field from the SQL Statement OR change it from "= NULL" to "is NULL". I've even done a txt dump of the report and it does not show anywhere within the report.
po_purchase_order_line.date_marked_as_deleted = null
I cannot find this field referenced in the report anywhere to either remove it or update it to "is null" If I copy paste the SQL Statement into a query of the databse it won't run unless I either remove the field from the SQL Statement OR change it from "= NULL" to "is NULL". I've even done a txt dump of the report and it does not show anywhere within the report.