Is there a way to add a connection string to CR instead of using a ODBC connection? I am using SQL Server authentication and for some reason the password will not store in my odbc connection, therefore everytime I run a report there is a prompt asking for login information.

Anyone got any ideas?