Since we upgraded our database to SQL 2005, Crystal has not been functioning properly. Specifically, the search function does not work and the hyperlinks to a different database pull incorrect data at times. For instance, if I want to see PO # 123, it will pull PO # 567, but this does not happen on a consistent basis.
Do I need to change the compatibility mode for the databased to SQL 2000 in order for Crystal to function properly?
Any input anyone can provide, will be greatly appreciated.