I had created a report using Reports designer connecting directly with the SQL Server name,database name userid and passwd. IN my ASP code when I change the SQL Server name alone it gives an error, only if I give teh saem server name as in design time it works properly. Is there any way to change the server at run-time? Thanks a lot.