Ad Hoc Reporting Properties

This option enables Ad Hoc reporting. Please note: If permissions are activated, the system permission for Ad Hoc reporting has to be set for each user who wants to use the Ad Hoc reporting tool.

Default value: true

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.

• Internal
  This option uses the built-in layouts of i-net Clear Reports, which provide layouts for all typical use cases with different generic styles.
• External directory
  With this option enabled, the Ad Hoc reporting tool will search an external directory for layout and data views. The layout and data views visible to the user can be restricted by setting permissions.
• Repository(Plus Feature)>With this setting, the Ad Hoc reporting will search the currently set repository in the sub-folder 'adhoc_root' for layouts and data views. The layouts and data views visible to the user can be restricted by setting report permissions.

Default value: 0

If the layouts and data view should be read from an external directory, this directory has to be set here.

If the repository is selected as the base directory of ad hoc, this options defines the subdirectory which will be scanned for layouts and data views. Leave this field empty to let ad hoc use the whole repository(not recommended).

Default value: adhoc_root

When enabled, this option allows any user to store his current 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. Possible values are

• Disabled
  Disables the feature.
• Directory
  Store the reports directly to the hard disk. Requires to set a target directory.
• Repository
  Requires a Plus-license and an active repository with user home enabled
  Stores the reports into a hidden folder in the user's home folder.

Default value: false

This options 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 this option is enabled, a user can use the Ad Hoc reporting tool even if he has no permissions for data sources or data views. The data uploaded by a user will be stored in the temporary directory of this 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.
Please note:
This feature is only visibile to users, who use dataviews since it generates a dataview. A user with datasource module permissions will get datasources instead of dataviews an therefore cannot use the CSV upload.

Default value: true

This option limits the amount of data a user is allowed to upload. If the limit is exceeded the upload will be aborted.

Default value: 1024

The column limit is the maximum number of columns allowed for a CSV file. If the limit is exceeded, the uploaded file is invalid and cannot be used. This option helps to prevent excessive load due to corrupt CSV files.

Default value: 100