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
    }