Setting a Default Interactive Reporting Database Connection

If you log on to one database more frequently than others, you should set the Interactive Reporting database connection file for that particular database as the default connection. Whenever you log on to create a new data model, the default Interactive Reporting database connection file loads automatically.

If you frequently use different databases in the work, you may not want to set a default Interactive Reporting database connection. If you leave the default Interactive Reporting database connection file preference blank, Interactive Reporting Studio prompts you to select an Interactive Reporting database connection file each time you log on.

  To set a default Interactive Reporting database connection file:

  1. Select Tools, then Options, and then Program Options.

    The Interactive Reporting Studio Options dialog box is displayed.

  2. Select File Locations tab to display the File Locations tab.

  3. In Connections Direction, enter the default connection directory that contains the Interactive Reporting database connection files you use to connect to different databases and click OK.

  4. In Default Connection, enter the full path and file name of the Interactive Reporting database connection file used as the default connection.

    The next time you log on (and create a new Interactive Reporting document file), the default Interactive Reporting database connection file is automatically used.

    Store your default Interactive Reporting database connection file in your connections directory so that Interactive Reporting Studio can find them when you or users of your distributed Interactive Reporting document files attempt to log on.