Skip to Content
Former Member
Jun 02, 2010 at 08:20 PM

Issue with report in viewer when using a temp table



I recently migrated from CRS XI R2 to CRS 2008. I have noticed that for reports that use a temporary table and attempted to be viewed in CRS 2008 do not work. However, in CRS XI R2, they used to work.

I am thinking this may be a setup issue on the CRS 2008 side. Does anyone know why the report viewer in CRS XI R2 works fine for a report but gets an error when viewed in CRS 2008 of the same report? The error message is Failed to Retrieve Data from the Database: Vendor Code 2714. (I am dropping the table before and after the query for extra assurance).

Thanks in advance,

Zack H.