08-27-2010 05:18 AM
We upgraded to 2010 12.1 and now our custom crystal report (call reports based on activity/notes by group) gives a :
Failed to open a rowset
Details: ADO Error Code: 0x0
Source: ACT! OleDB Provider for reporting 2.0
Description: Invalid object name '#GROUP_CONTACT'.
Native Error: -2147217865
Any help would be much appreciated.
08-27-2010 06:25 AM
08-27-2010 06:38 AM
Thank You for the quick reply.
If I understood correctly...
I made a copy of one of the reports, then went to "Set datasource location" and re-mapped all the fields.
Result was the same error at the same point in the report.
08-27-2010 09:08 AM
The error has been isolated to a subreport that deals with the Activity tables. Removing the subreport allows the original report to run.
The subreport isolated gives the same error message.
I have re-linked the sub-report tables and remain baffled.