Skip to main content

Crosstab Formula Editor Dialog Box

  • Updated

BackPrevious Topic  Next TopicNext

Crosstab Formula Editor Dialog Box

You can use the Crosstab Formula Editor dialog box to create custom aggregate functions in a crosstab using crosstab formulas. This topic describes the options in the dialog box.

Designer displays the Crosstab Formula Editor dialog box when you select a crosstab component, on the Data panel select <New Crosstab Formula...> under the Crosstab Formulas node, type a name for the new crosstab formula and then select OK, or right-click a crosstab formula and select Edit Formula on its shortcut menu.

Crosstab Formula Editor

You see the following options in the dialog box:

Menu

  • File
    • New Formula
      Select to create a formula.
    • New Summary
      Select to open the New Summary dialog box to create a summary.
    • New Parameter
      Select to open the New Parameter dialog box to create a parameter.
    • Import UDF Classes
      Select to open the UDF Classes dialog box to import user-defined formula classes.
    • Save
      Select to save the crosstab formula.
    • Save As
      Select to save the crosstab formula as a new crosstab formula by specifying a new name.
    • Close
      Select to close the dialog box.
  • Edit
    • Undo
      Select to undo an action.
    • Redo
      Select to redo an action.
    • Cut
      Select to cut the specified text in the editing panel.
    • Copy
      Select to copy the specified text in the editing panel.
    • Paste
      Select to paste the text that you cut or copied in the editing panel.
    • Delete
      Select to delete the specified ted text in the editing panel.
    • Search
      Select to open 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
      Select to show the Fields panel.
    • Functions Panel
      Select to show the Functions panel.
    • Operators Panel
      Select to show the Operators panel.
    • Sort Tree
      Select to sort the functions in the Functions panel and fields in the Fields panel by names.
  • Formula
    • Check
      Select to test the syntax of your crosstab formula. If the syntax is incorrect, Designer gives the opportunity to correct the errors.
    • Add Bookmark
      Select to add a bookmark to a specific position.
    • Go to Previous Bookmark
      Select to go to the previous bookmark.
    • Go to Next Bookmark
      Select to go to the next bookmark.
    • Clear all Bookmarks
      Select to clear all of the bookmarks.
    • Comment/Uncomment
      Select to add or remove comments.
    • Add Operators
      Select to add a general operator in the editing panel.
    • Color Converter
      Select to open the color palette to insert the HEX code of a color.
    • Auto Finish
      Select to enable the automatic input of the other part of a sign pair right after you type in the first part when editing the crosstab formula.
    • Formula References
      Select to show the formulas that reference the selected UDF function in the Functions panel.
    • Properties
      Select to show the properties of the crosstab formula in the Formula Properties dialog box.
      • Data Type
        The property shows the data type of the return value of the crosstab formula.
      • Precision
        Specify the precision of the return value of the crosstab formula. If the precision is set to 0, all characters of the return value will be displayed; if it is set to N, only the first N characters will be displayed.
      • Scale
        Specify the number of digits to the right of the decimal point for the return value of the crosstab formula.
  • Help
    Select to view information about the dialog box.

Toolbar

  • New Formula
    Select to create a crosstab formula.
  • New Summary
    Select to create a summary.
  • New Parameter
    Select to create a parameter.
  • Save
    Select to save the formula.
  • Save As
    Select to save the formula as a new formula by specifying a new name.
  • Properties
    Select to show the properties of the crosstab formula in the Formula Properties dialog box.
    • Data Type
      The property shows the data type of the return value of the crosstab formula.
    • Precision
      Specify the precision of the return value of the crosstab formula. If the precision is set to 0, all characters of the return value will be displayed; if it is set to N, only the first N characters will be displayed.
    • Scale
      Specify the number of digits to the right of the decimal point for the return value of the crosstab formula.
  • Sort Tree
    Select to sort the functions in the Functions panel and fields in the Fields panel by names.
  • Fields Panel
    Select to show the Fields panel.
  • Functions Panel
    Select to show the Functions panel.
  • Operators Panel
    Select to show the Operators panel.
  • Help
    Select to view information about the dialog box.
  • Cut buttonCut
    Select to cut the specified text in the editing panel.
  • Copy buttonCopy
    Select to copy the specified text in the editing panel.
  • Paste buttonPaste
    Select to paste the text that you cut or copied in the editing panel.
  • Delete buttonDelete
    Select to delete the specified text in the editing panel.
  • Undo buttonUndo
    Select to undo an action.
  • Redo buttonRedo
    Select to redo an action.
  • Search buttonSearch
    Select to open the Find/Replace dialog box to search for text in the editing panel, and replace the found text with different text.
  • Check buttonCheck
    Select to test the syntax of the crosstab formula. If the syntax is incorrect, Designer gives you the opportunity to correct the errors.
  • Add Bookmark buttonAdd Bookmark
    Select to add a bookmark to a specific position.
  • Go to Previous Bookmark buttonGo to Previous Bookmark
    Select to go to the previous bookmark.
  • Go to Next Bookmark buttonGo to Next Bookmark
    Select to go to the next bookmark.
  • Clear All Bookmarks buttonClear All Bookmarks
    Select to clear all of the bookmarks.
  • Comment/Uncomment buttonComment/Uncomment
    Select to add or remove comments.
  • Add Operators buttonAdd Operators
    Select to add a general operator in the editing panel.
  • Color Converter buttonColor Converter
    Select to open the color palette to insert the HEX code of a color.

Fields panel

The panel displays a list of the fields that are available for crosstab formulas. Those fields contain table columns, formulas, parameters, special fields, and other crosstab formulas. Select one field and double-click it to insert it into the editing panel at the insertion point.

Functions panel

The panel displays a list of the Logi Report built-in functions and imported user defined formula functions that are available for crosstab formulas. When you select one function and double-click it, Designer inserts the selected function into the editing panel at the insertion point completely with its required syntax items (parentheses, commas, and so on).

Operators panel

The panel displays a list of the Logi Report built-in operators that are available for crosstab formulas. Select one operator and double-click it to insert the selected operator into the editing panel at the insertion point.

Formula text panel

You can edit your crosstab formula in this panel. There are several ways to work with crosstab formula:

  • Select formula components from the Fields, Functions, and Operators panels, and then double-click the components, Designer then inserts them in the crosstab formula.
  • Type your crosstab formula in the editing panel directly.
  • Use the above two methods together.
  • Paste crosstab formula text from the text document of other programs.

Designer marks the line numbers of the crosstab formula in the left of the panel to help you check it easily.

BackPrevious Topic  Next TopicNext