Is there a way to store the password for the database so that the user does not have to enter it every time?
Generally, you can save the
Generally, you can save the username and password. The details on how to do this generally depend on your database type, and the way you are connecting to it.
I am connecting to a SQL
I am connecting to a SQL database through ODBC
Override the database
Override the database connection with the "Server" and the "Database" fields both containing your ODBC DSN. Then it should work fine.
My report is actually
My report is actually accessing 2 databases from the same server. How do I handle that? It seems that the override will only allow me to choose one.
Yeah, that's a problem.
Yeah, that's a problem. Sorry.
Override Connection Settings with Username and Password Only
If you override the connection settings, and set the nickname, username, and password, then it won't prompt. You can leave the server and database fields, and it will use the values from the website.