Ad hoc reporting enables anyone to generate new reports quickly and easily. With just a few clicks, the report's data and form of presentation can be selected before the report is run.
The following general options allows setting up the overall functionality of ad hoc reporting.
Defines the default render format for ad hoc reports. The following formats are available:
Ad hoc reporting loads both its layouts and data views from a directory structure and its sub-directories. This option defines which type of directory will be used.
templates
of the installation.If the layouts and data view should be read from an external directory, this directory has to be set here.
If the i-net Drive is selected as the base directory of ad hoc reporting, this options defines the subdirectory which will be scanned for layouts and data views. Leave this field empty to let ad hoc reporting use the whole Drive (not recommended).
When enabled, this option allows any user to store their created ad hoc report. These ad hoc reports can be reloaded on demand on the reports page, allowing the user to continue an ad hoc report. The following options are available:
The Root Directory option sets the directory where the ad hoc reports stored by the user are located on your server. The user store feature will only be available if this directory is set and exists.
The data upload feature enables your users to upload their own data in form of CSV files and to design and execute ad hoc reports using this data.
If CSV data upload option is enabled, user can use the ad hoc reporting tool even if they have no permissions for data sources or data views. The data uploaded by a user will be stored in the temporary directory of the server and will be overwritten on any subsequent upload or, in case of an anonymous user, when the session expires or the user logs out.
Note: The feature is only visible to users configured to use Dataviews since it generates a dataview from the uploaded CSV. A user with datasource module permissions will get datasources instead of dataviews and therefore will not be able to upload CSVs.
This option limits the amount of data a user is allowed to upload. If the limit is exceeded the upload will be aborted.
The column limit is the maximum number of columns allowed for a CSV file. If the limit is exceeded, the uploaded file will be handled as invalid and cannot be used. This option helps to prevent excessive load due to corrupt CSV files.
Enable users to download rendered report files created using ad hoc reporting.
The Download/Upload of save points option enables users to download the current configuration of their ad hoc session. The downloaded file can be uploaded to any ad hoc session of any user to re-create the configuration in this session. This settings file does not contain security relevant data.
Any user of the ad hoc interface can download the resulting report in addition to rendering it when the download option is enabled. The downloadable file is a complete report file and can be executed and edited by the i-net Designer as well. For security reasons the report file only contains the name of the referenced data source, it never contains the actual connection settings.