options.json

You can configure the following options in an options.json file in the root of the web application folder:

• schedulerconnectionstring: A connection string for a SQL Server database to use for the scheduler. Only specify this if running Horizon Reports in Clustered Mode

  {
    "schedulerconnectionstring": "Data Source=dbserver;Initial Catalog=SQSchedules;uid=sa;pwd=sapassword"
  }
  

• cacheconnectionstring: A connection string for a SQL Server database to use as system cache. Only specify this if running Horizon Reports in Clustered Mode

  {
    "cacheconnectionstring": "Data Source=dbserver;Initial Catalog=SQDistCache;uid=sa;pwd=sapassword"
  }
  

• logintimeout: The inactive time in minutes before a user is automatically logged out. The default setting is 20 minutes. This means that if a user closes their browser without logging out, it will take 20 minutes for the the license occupied by that user to be freed for use with another user.

  {
    "logintimeout": 20
  }
  

• cookiename: The name the cookie sends to the browser. Set this value if you need to change the name of the cookie that Horizon Reports sends to the browser.

  {
    "cookiename": "ReportingCookie"
  }
  

options.json example

Here is an example of an options.json file with all configuration options specified

{
    "cacheconnectionstring": "Data Source=dbserver;Initial Catalog=SQDistCache;uid=sa;pwd=sapassword",
    "schedulerconnectionstring": "Data Source=dbserver;Initial Catalog=SQSchedules;uid=sa;pwd=sapassword"
    "logintimeout": 5,
    "project": "C:\\MyProjects\\Northwind\\Project_Data\\settings.xml",
    "appsettings": "C:\\MyProjects\\Northwind\\App_Data\\applicationsettings.xml",
	"cookie": "ReportingCookie"
}

hrsettings.json

You can configure the following options in an hrsettings.json file. The default location for this file is in the Project_Data folder. However, it’s also supported in the root of the web application folder:

• DefaultConnectionString: A connection string for a database that stores the projects for this installation.

  {
    "DefaultConnectionString": "Data Source=Project_Data\\horizonreports.db"
  }
  

• ConnectionType: The type of database that stores the projects. SQLite, SqlServer, and MySql are supported options.

  {
    "ConnectionType": "SQLite"
  }
  

• AppDataConnectionString: A connection string for a database that stores the application data (reports, users, tags, etc…).

  {
    "AppDataConnectionString": "Data Source=App_Data/hrdata.db"
  }
  

• AppDataConnectionType: The type of database that stores the application data. SQLite, SqlServer, and MySql are supported options.

  {
    "ConnectionType": "SQLite"
  }
  

• CurrentProject: The database ID of the project to load in the report writer. Normally you would change this value in the Horizon Reports Studio interface.

  {
    "CurrentProject": 1
  }