This dialog contains properties to specify additional classes to the classpath, e.g. for user defined formulas, servlet filter and language resources for report translations. Also, the default collation can be changed in this dialog.

List of directories and files that will be added to classpath of the server or application during startup. Use this property to add JDBC drivers, JavaBeans, your own ReportServlet or Database class implementations.

Examples Entries:

• C:/ClearReports/libs
• C:/jdbcdriverCSv/Fositex.jar
• C:/jdbcdriverMSSQL/Merlia.jar
• C:/ClearReports/libs
• C:/jdbcdriverCSv/Fositex.jar
• C:/jdbcdriverMSSQL/Merlia.jar

To use "User Defined Functions" in your reports, you have to implement them in your own classes. These classes have to be added to the classpath of the server or application (e.g. create and copy a jar file into the "lib" directory) and need to be specified by their fully qualified class name.

• com.mycompany.MyTest
• com.mycompany.MyDateFormulas

Using a PropertiesChecker class the system can filter and modify properties of the server at certain points of a request. This class needs to implement the com.inet.report.PropertiesChecker interface.

For detailed information about the PropertiesChecker, please refer the API documentation.

List of optional servlet filters. These classes have to implement javax.servlet.Filter. Per default the list of filters is empty.

This specifies the resource file for language independent labels. If the name of the default language resource file is: Language.class or Language.properties and it is located in the package: MyPackage then the value of the property LanguageResource needs to be specified as:

MyPackage.Language

The default language resource file (e.g., Language.properties) should contain the labels for the default language (e.g., English). This default language resource file will be used if the language resource file for the requested language was not found.

Hint: In order to use the language resources, please activate the option "Use Client Locale".

The collation property allows setting of locale-sensitive String comparison.

If this property is activated, the default collation defined in the configuration will be used. Otherwise the en_US Locale will be used to sort the data case-insensitive.

• Default value: Activated

This property allows the setting of language (Locale, e.g. en_US) which defines the collation rules of strings. Note: To use this option please check that your database supports case sensitive comparison and uses the same locale.

• Default value: en_US

The strength defines the comparison rules. The assignment of strengths to language features is locale dependant. Four strengths are provided:

• PRIMARY - only primary differences, for example "a" vs "b".
• SECONDARY - locale-sensitive differences and above, for example "a" vs "ä".
• TERTIARY - case sensitive differences and above, for example "a" vs "A".
• IDENTICAL - all differences are considered significant during comparison.

For more information please see java.text.Collator. Note: To use this option please check that your database supports case sensitive comparison and applies same locale.

• Default value: PRIMARY