Home User Manual Discussion Forum Search

Report Setup - Report Server

A report server can be useful to large offices to prevent lockups and slowness in a live database. Currently the report server can only run the Production and Income Reports.

There are two connection options:

Note: Always keep the report server database up-to-date so reports are run on current data.

To set up the Report Server:

  1. In the main menu click Reports, Standard Reports.
  2. Click Setup in the upper left corner.



  1. Open the Report Server tab.



  1. Check 'Use separate reporting server' to enable the connection settings.
  2. Enter the connection credentials for the desired connection method (see below).
  3. Click OK to save.

Direct Connection

  • Server Name: The name of the computer acting as the report server.
  • Database: The database to connect to.
  • MySQL User: Default user is 'root'. See MySQL Security.
  • MySQL Password: The user password (if you have set up mySQL users and password).

Middle Tier

  • URI: If you do not know your URI, see Middle Tier Troubleshooting for help.

Note: When connecting via Middle Tier, the credentials of the logged on user are used to access the database.

 

Open Dental Software 1-503-363-5432