Introduction
Choosing Database Mode or Filesystem Mode
Izenda Reports features two methods for saving reports, file system mode and database mode. The default is the Filesystem mode. The table shown will help you choose whether or not you use database or filesystem mode. If you find you need any one of these in either column, choose that storage mode.
| Database |
Filesystem |
| Not allowed to save to server on which Izenda Reports is installed |
Need to customize the way reports are saved or shared |
| The most security by keeping it in your database |
Designing reports on a test server and then deploying them |
| Don't want to change default behaviors |
Need to copy reports between servers for use |
| Fixed Schema |
Schema of database is changed at all |
The mode is set in the global.asax file which is found in the root directory to which you installed Izenda Reports. In the example below, the setting in bold is the actual code which must be changed to set database or filesystem mode.
Setting Filesystem Mode (Set by default)
//C#public class CustomAdHocConfig : Izenda.AdHoc.FileSystemAdHocConfig
//VB.NETPublic Class CustomAdHocConfig Inherits Izenda.AdHoc.FileSystemAdHocConfig
Setting Database Mode //C#public class CustomAdHocConfig : Izenda.AdHoc.DatabaseAdHocConfig
//VB.NETPublic Class CustomAdHocConfig Inherits Izenda.AdHoc.DatabaseAdHocConfig
File System Mode
This is the default saving mode for Izenda Reports. If in this mode, then by default, Izenda Reports saves to a folder called "Reports". No data is stored in the database which is being queried by Izenda Reports. One of the advantages of file system mode is that it allows for custom saving behavior. There are four main methods which control creating, loading, saving and deleting reports: Each of these methods may be over-ridden in order to implement custom behavior. Please see the global.asax.example file and the Izenda Reports API for examples. To set the default reports folder path which Izenda Reports should use, you must first create a folder in the file system and then ensure that the NETWORK SERVICE machine account has read and write access if using ASP.NET 2.0 or that the ASP.NET machine account has read and write access if using ASP.NET 1.1. Now tell Izenda Reports which folder to use by setting the "ReportsPath" property as shown in the example. Setting the Saved Reports Path
//C#Izenda.AdHoc.AdHocSettings.ReportsPath = "\SomePath";
//VB.NETIzenda.AdHoc.AdHocSettings.ReportsPath = "\SomePath"
Database Mode
This is the alternative saving mode for Izenda Reports. Izenda Reports creates a default table in the database, IzendaAdHocReports, to save the report data. In this mode, no data is stored in the Reports folder in the Izenda Reports directory. To set the default table which Izenda Reports should use, you must first create a table in the database and then ensure that the NETWORK SERVICE machine account has owner access if using ASP.NET 2.0 or that the ASP.NET machine account has owner access if using ASP.NET 1.1. Now tell Izenda Reports which table to use by setting the "SavedReportsTable" property as shown in the example. Setting the Saved Reports Table C#
//C#Izenda.AdHoc.AdHocSettings.SavedReportsTable = "SomeTableName";
//VB.NETIzenda.AdHoc.AdHocSettings.CSavedReportsTable = "SomeTableName"
It is possible to copy the reports when necessary to the Reports folder in the Izenda Reports directory by using the "Administrative Settings" button on the toolbar in the report designer. In the status screen, click "Copy reports from database to file system." This will place the files in the Reports folder in the Izenda Reports directory.