08-04-2015 12:00 PM
I use Crystal Reports for to write reports for ACT.
When i set up the connection for Crystal Reports using the "ACT! OLE DB Provider for Reporting 2.0" it prompts me for my usersname and password. The report runs fine.
When i close the report and open it to run it again, i am immendiately prompted to enter the data source, username and password everytime.
Idid some testing and if the user has no password, it doesn't prompt and the report will just run. It appears that it is the password not getting stored with the report. Anyone know how to get the username and password saved in the report?
08-04-2015 01:27 PM
It's connecting to the ACT! database and using the ACT! login rules, a single user database without a use password will open without a login, a single use database where the user has a password will always have a login prompt.
08-20-2015 03:25 PM
I have written an addon called Crystal Clear Provider that will run the reports for you. There will soon be a new version out that doesn't require the user to log in to run the reports. The reports will show up on the menu and can be run from there once the user logs into Act!. If you'd like to see how it works you can download Crystal Clear Essentials which includes 60+ reports. Crystal Clear Provider is quite a bit less expensive since the reports aren't included. You can download the installer for CCE at the following link. It will also install the latest Crystal Reports for Visual Studio runtime.