Previous Topic  Next Topic

User Defined Function Editor Dialog Box

The User Defined Function Editor dialog box helps you to write a user-defined function (UDF) which can be called in a formula or another user-defined function. It appears when you do either of the following:

• In the Catalog Manager, right-click the User Defined Functions node, select New Function on the shortcut menu, type a name for the new function and then select OK, or right-click a UDF and select Edit from the shortcut menu.
• In the Data panel, right-click a UDF and select Edit from the shortcut menu.
• Select <New Function…> under the User Defined Functions node where a formula list is provided.

The following lists all the options that are provided in the editor. Some of them are not available depending on where the editor is opened.

Menu

• File
  • New Function
    Creates a new function.
  • New Summary
    Opens the New Summary dialog box to create a new summary.
  • New Parameter
    Opens the New Parameter dialog box to create a new parameter.
  • Import UDF Classes
    Opens the UDF Classes dialog box to import user-defined formula classes.
  • Save
    Saves the function.
  • Save As
    Saves the function with a different name.
  • Close
    Closes the window.
• Edit
  • Undo
    Undoes an action.
  • Redo
    Redoes an action.
  • Cut
    Cuts the selected text in the editing panel.
  • Copy
    Copies the selected text in the editing panel.
  • Paste
    Pastes the text that was previously cut or copied in the editing panel.
  • Delete
    Deletes the selected text in the editing panel.
  • Search
    Brings out the Find/Replace dialog box. You can then search for text in the editing panel, and replace the found text with different text.
• View
  • Fields Panel
    Specifies whether to show the Fields panel.
  • Functions Panel
    Specifies whether to show the Functions panel.
  • Operators Panel
    Specifies whether to show the Operators panel.
  • Sort Tree
    Sorts functions in the Functions panel and fields in the Fields panel by names.
• User Defined Function
  • Check
    Tests the syntax of your function. If the syntax is incorrect, Logi Report gives the opportunity to correct the errors.
  • Add Bookmark
    Adds a bookmark to a specific position.
  • Go to Previous Bookmark
    Goes to the previous bookmark.
  • Go to Next Bookmark
    Goes to the next bookmark.
  • Clear All Bookmarks
    Clears all of the bookmarks.
  • Comment/Uncomment
    Adds or removes comments.
  • Add Operators
    Specifies a general operator to be used in the editing panel.
  • Color Converter
    A color palette is provided for you to insert the HEX code of a color.
  • Auto Finish
    Enables the automatic input of the other part of a sign pair right after you type in the first part when editing functions.
  • User Defined Function References
    Shows the user-defined functions that reference the selected UDF method in the Functions panel.
• Help
  Displays the help document about this feature.

Toolbar

Lists the commands on the toolbar.

• New Function
  Creates a new function.
• New Summary
  Creates a new summary.
• New Parameter
  Creates a new parameter.
• Save
  Saves the function.
• Save As
  Saves the function with a different name.
• Sort Tree
  Sorts functions in the Functions panel and fields in the Fields panel by names.
• Fields Panel
  Specifies whether to show the Fields panel.
• Functions Panel
  Specifies whether to show the Functions panel.
• Operators Panel
  Specifies whether to show the Operators panel.
• Help
  Displays the help document about this feature.
• Cut
  Cuts the selected text in the editing panel.
• Copy
  Copies the selected text in the editing panel.
• Paste
  Pastes the text that was previously cut or copied in the editing panel.
• Delete
  Deletes the selected text in the editing panel.
• Undo
  Undoes an action.
• Redo
  Cancels undoing an action.
• Search
  Searches for text in the editing panel, and replace the found text with different text.
• Check
  Tests the syntax of your function. If the syntax is incorrect, Logi Report gives the opportunity to correct the errors.
• Add Bookmark
  Adds a bookmark to a specific position.
• Go to Previous Bookmark
  Goes to the previous bookmark.
• Go to Next Bookmark
  Goes to the next bookmark.
• Clear All Bookmarks
  Clears all of the bookmarks.
• Comment/Uncomment
  Adds or removes comments.
• Add Operators
  Selects a general operator to be used in the editing panel.
• Color Converter
  A color palette is provided for you to insert the HEX code of a color.

Fields panel

Displays a list of fields that are available to functions. Those fields may contain table columns, business view elements, formulas, summaries, parameters and special fields. Select one field and double-click it to insert it into the editing panel at the insertion point.

Functions panel

Displays a list of the Logi Report built-in functions and user-defined functions that are available to functions. When you select one function and double-click it, Logi Report will insert the selected function into the editing panel at the insertion point completely with its required syntax items (parentheses, commas, and so on).

Operators panel

Displays a list of the operators that are available to functions. Select one operator and double-click it to insert it into the editing panel at the insertion point.

Function text panel

In this panel, you can build and edit your function. There are several ways to work with functions:

• Select function components from the Fields, Functions and Operators panels, and then double-click the components, Logi Report will then insert them in the function;
• Type your function in the editing panel directly;
• Use the above two methods together;
• Paste function text from the text document of other programs.

The line numbers of the function are marked in the left of the panel to help you check it easily.

Previous Topic  Next Topic