Add User Defined Data Source dialog

This dialog appears when you right-click the User Defined node and select Add User Defined Data Source from its shortcut menu in the Catalog Browser. It is used to add user data source objects into a JReport catalog. See the dialog.

The following are details about options in the dialog:

Name

Specifies the name of the UDS. The name cannot be the same as any of the existing procedures, SQL files, HDSs, business cubes or queries. It also cannot be empty.

Class Name

Specifies the full name (including package name) of the class represented by the UDS. The class should be appended to the class path in the system environment.

The class implements

After filling in the Class Name field, the classname of the interface that the class implements will be displayed here.

Parameter

Specifies the parameter string for the UDS. The parameter string must match the format defined in the UDS class. You can use parameters or constant level formulas predefined in a JReport catalog or the special field UserName in the parameter string, and the format of the predefined parameters used in the string is "@" + parameter name. For example, if the parameter string of a UDS is SQL=select * from employee, and you want to use the parameter sql in a catalog to replace the part after "=" in the string, then the parameter string of the UDS will be SQL=@sql.

Edit Format

Opens the Edit Parameter Format dialog, in which you can edit the parameter format:

Specify Columns

Specifies the column definitions. If you don't specify the column definitions, JReport will retrieve them from result set.

Adds a default row in the column definitions. If there is no row selected, an empty row will be added to the last line.

Removes the selected row.

Moves the selected column one step up.

Moves the selected column one step down.

OK

Adds the UDS and closes the dialog.

Cancel

Does not retain any changes and closes the dialog.

Help

Displays this help document.

Related topics: