What I'm doing is trying to pass an SQL query to a Crystal Report. The problem I am having is that I am using temporary tables from which I run these queries, and the names of these tables are different, but all pointing to the same Crystal Report. So far I have been unable to pass the name of the table to a Crystal Report and the fields in the report seem to be bound to a table that I have chosen when designing the report. Is there any way to override the connection to that table with the one I want? I am not very experienced with Crystal Reports so if anyone could point me in the right direction it would be greatly appreciated.

Thanks. Ben