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,