Configure a Report Service
- 2 minutes to read
To store temporary data (generated documents, files ready for export and so on), the report service uses a cache, which may be located in memory or in a database. By default, a Microsoft SQL Server database is used, but you can use any database to which it is possible to connect using XPO. To view the full list of the supported database formats, refer to the Database Systems Supported by XPO topic.
By default a report service stores its cache in a database specified by the connection string named xpf.printing:
<connectionStrings> <add name="xpf.printing" connectionString="xpoprovider=MSSqlServer; data source=(localdb)\v11.0; attachdbfilename=|DataDirectory|\ReportService.mdf; integrated security=True;connect timeout=120" /> </connectionStrings>
If no connection string is specified, the cache is stored in memory.
For more information on connection strings, review the following help article: Database Systems Supported by XPO.
The name of a connection string used to access the cache may be changed by specifying the documentStore.connectionStringName parameter in the Web.config file, or by implementing the IDocumentDataStorageProvider MEF extension (for more information, see Extend a Report Service with Custom Functionality).
It is strongly advised that you use a separate database instance for storing the report service cache. This allows you to safely delete the cache, which may be required for migrating between different versions of DevExpress controls.
Additional parameters are set in the xpf.printing configuration section (e.g., the life-cycle of the database entities in milliseconds that is defined by the keepInterval parameter).
<devExpress> <xpf.printing> <documentStore keepInterval="1200000" connectionStringName="xpf.printing" /> </xpf.printing> </devExpress>
The server automatically creates the database scheme when the first connection is set up.