SQL Command with Temp tables & Unions fails in BOXIR2

[Flopper]

Hi all,

I'm having a problem with a SQL command as a data source in Crystal Reports XI. This command fairly straightforward but contains three Temp tables, a couple of Unions and the Temp Table Drop commands.

Within Crystal Reports XI the query works perfectly well, but as soon as the report is added to BOXIR2 and scheduled I receive an error with "The table could not be found".

The report has been configured correctly within BOXIR2. I have also created a test report using a SQL Command with Temp table creation and drop commands, and the report schedules successfully.

I am using SQL Server 2005.

Any help would be greatly appreciated.

Thanks

 

[IanWaterman]

Why don't you just convert your command to a stored procedure and report off that.

Pretty sure that commands in Crystal will not perform like a stored Proc.

Ian