Issue

Installing Jet Reports with Standard Options and Connections
Solution

Automatic Installation with Custom Installation Options

If you want to create an automatic installation with custom options, first install Jet Reports on a typical computer and configure all of the options as described above. If you are using Database Logins, delete your User Name and Password so they will not be installed on other computers. Next export your options to a file named DefaultOptions.JOP and replace the DefualtOptions.JOP file in the installation directory you just created. If you unzipped the Jet Installation to R:\Installer, you will find the DefaultOptions file in the 'R:\Installer\Program Files\JetReports' folder. When you install Jet Reports from this location, it will copy the DefaultOptions.JOP folder to the local computer. The first time a user activates Jet Reports, it will use the options stored in DefaultOptions.JOP. If the DefualtOptions.JOP file specifies Auto Import Options, options will be read from the specified file as explained above.

Regardless of how you decide to configure Jet Reports, the Excel options and Jet Reports options are stored on a Per-User basis. This means that each user will have to run 'Activate' from the Start Menu to get access to Jet and enter their username and password. It also means that your database security will be maintained since each user's credentials are stored separately.