I am using the "save as --> enterprise" command in crystal report designer to deploy reports to CMC server. However, after every time I save the report, I am prompted with the database password when I try to view the report.
Is there any way to prevent the prompt after each deployment?
Or Is there a way to setup some connections in the server and then made accessible in the crystal report designer? (As far as I know, one can set universe in the server, by the way, it is not suitable in our case as we need to retrieve data with plain SQL queries)