Hello
I have a stored procedure on MS SQL 2005 Server and I will use them in a report (set location). An "SQL Native Client" - Connection will be used.
On Crystal Report XI it works fine, but with Crystal Reports 2008 an error occurs (same ODBC, stored procedure and DB):
Error: 42S02 [SQL Native Client][SQL Server] Invalid object Name '#temp_table'.
In the procedure the temp table is created (create #temp_table ...) but the error comes when I will access the table
after some other code.
Can someone help me?
Best regards
Stephan