Crosstab Formula Editor window
This window appears when you select a crosstab component, on the Resource View panel click <Add Crosstab Formula...> under the Crosstab Formulas node, input a name for the new crosstab formula and then click OK, or right-click a crosstab formula and click Edit Formula on its shortcut menu. It helps you to add crosstab formulas, summaries and parameters and then make certain operations on them. See the window.
The following are details about options in this window:
File menu
- New Formula
Creates a new formula.
- New Summary
Opens the New Summary dialog to create a new summary.
- New Parameter
Opens the Create Parameter dialog to create a new parameter.
- Import UDF Classes
Opens the UDF Classes dialog to import user defined formula classes.
- Save
Saves the crosstab formula to the Formulas node.
- Save As
Saves the crosstab formula as a new crosstab formula by specifying a new name.
- Close
Closes the window.
Edit menu
- 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. You can then search for text in the editing panel, and replace the found text with different text.
View menu
- 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.
Formula menu
- Check
Tests the syntax of your crosstab formula. If the syntax is incorrect, JReport 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 simply by clicking the corresponding color in the color palette instead of inputting the HEX code manually. If the color palette cannot meet your requirement, click More Color to open the Pick a Color dialog, then you can set a full range of color in the dialog.
- Auto Finish
Enables the automatic input of the other part of a sign pair right after you type in the first part when editing crosstab formula.
- Formula References
Shows the formulas that reference the selected UDF function in the Functions panel.
- Properties
Shows properties of the crosstab formula in the Formula Properties dialog.
- Data Type
The data type of the returned value of the crosstab formula.
- Precision
The precision of the returned value of the crosstab formula. If the precision is set to 0, all characters of the returned value will be displayed; if it is set to N, only the first N characters will be displayed.
- Scale
The number of digits to the right of the decimal point for the returned value of the crosstab formula.
Help menu
- Crosstab Formula Editor help
Displays this help document.
Toolbar
The following are commands on the toolbar:
- New Formula
Creates a new crosstab formula.
- New Summary
Creates a new summary.
- New Parameter
Creates a new parameter.
- Save
Saves the formula to the Formulas node.
- Save As
Saves the formula as a new formula by specifying a new name.
- Properties
Specifies the precision and scale properties of the crosstab formula.
- 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.
- Formula Editor Help
Displays this help document.
- 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 crosstab formula. If the syntax is incorrect, JReport 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 simply by clicking the corresponding color in the color palette instead of inputting the HEX code manually.
Fields panel
Displays a list of those 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
Displays a list of JReport functions and imported user defined formula functions that are available for crosstab formulas. When you select one function and double-click it, JReport will insert the selected function into the editing panel at the insertion point completely with its required syntax items (parentheses, commas, etc). For the usage of these functions, refer to section Built-in functions and User-defined formula functions.
Operators panel
Displays a list of 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. For the usage of these operators, refer to section Operators.
Formula text panel
In this panel, you can build and edit your crosstab formula. There are several ways to work with crosstab formula:
- Select formula components from the Fields, Functions and Operators panels on the top of Crosstab Formula Editor, and then double-click the components, JReport will then insert 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.
The line numbers of the crosstab formula are marked in the left of the panel to help you check it easily.
Related topics: