3 Working with Form Controls

This chapter contains the following topics:

3.1 Understanding Form Controls

Use form controls to provide specific functions within an application such as these:

  • Insert field controls on forms to display data, enter data, calculate data, store data permanently or temporarily, or pass data between fields and forms.

  • Place check boxes on forms to provide for multiple selections, or radio buttons to indicate mutually exclusive selections.

Each form includes specific default controls, depending on the type of form that you are creating. However, you might need to add additional controls when you design the form. Choose from standard Windows graphical controls as well as JD Edwards EnterpriseOne custom controls.

All form controls are locked by default, this is seen by a "NO" cursor when mouse is hovered over the controls. The controls can be unlocked by clicking on the Form menu and selecting Lock Form Controls. This option will unlock the selected form for modifying controls. An information message box will display when you launch an application to indicate if the form is in lock mode. (Release 9.1 Update 2)

When controls are hidden they are by default not viewable in FDA. To view the hidden controls click the Show Hidden Controls in the Form menu. Hidden controls will be displayed in blue italic text. (Release 9.1 Update 2)

This table lists the controls, the forms on which they can be used, and their purpose:

Control Valid Form Types Description
Calendar All Form Types Use a calendar control to provide standard calendar capabilities to users which can be tied to some system events.
Check Box All Form Types Use one or more check boxes to provide the user with options that are not mutually exclusive.
Combo Box All Form Types Use combo box to provide user a drop down list of items.
Edit All Form Types Use edit fields to display data and to enable users to enter information for a specific instance of a data item.
Grid control Browse Portlet

Edit Portlet

Find/Browse (default control)

Header Detail (default control)

Headerless Detail (default control)

Power Browse (default control)

Power Edit

Reusable Browse Subform

Reusable Edit Subform

Search & Select (default control)

Wizard (page only)

 Use grids to display data and to enable users to enter information. Unlike an edit control, grid controls can show multiple data items and multiple table rows at once.
Group All Form Types Use this control to group other controls together visually.
Image All Form Types Use image controls to place a static or animated graphic on a form.
Media Object All Form Types Use media object controls to enable users to enter rich text and attach files to a form.
Parent Child Browse Portlet

Edit Portlet

Reusable Browse Subform

Reusable Edit Subform

Parent/Child Browse (default control)

Power Edit

Wizard (page only)

 Use parent child controls to present a hierarchical grid view or a tree view.
Push Button All Form Types Use a push button to initiate an action or a set of actions.
Radio Button All Form Types Use radio buttons to provide the user with sets of options. The radio buttons in each set are mutually exclusive.
Saved Query Control Browse Portlet

Edit Portlet

Find/Browse

Header Detail

Headerless Detail

Parent/Child Browse

Power Edit

Power Browse

Reusable Browse Subform

Reusable Edit Subform

Search & Select

Wizard (page only)

 Use a saved query control to enable users to create and save data queries and to provide them with a set of queries from which to choose.
Static Text All Form Types Use static text as labels on the form.
Subform Browse Portlet

Edit Portlet

Reusable Browse Subform

Reusable Edit Subform

Power Edit

Power Browse

Wizard (Wizard control only)

 Use subforms to provide one BV and a group of controls associated with it. Place multiple subforms on a power form to provide multiple, collective data views on one form. The subform created this way will not be reusable by other forms or applications.
Subform Alias Browse Portlet

Edit Portlet

Reusable Browse Subform

Reusable Edit Subform

Power Browse

Power Edit

Wizard

 Use a subform alias to place a reusable subform on the form. A reusable subform is a subform with a data view and a set of controls associated with it.
Tab Control All Form Types Use tab controls to present a large number of controls on one or more tab pages. Power forms can have any number of tab controls, but all other forms are restricted to one. You cannot use tab control on a subform that is a tab page.
Tab Page Only apply to tab controls Use a tab page control to define one page in a tab control.
Text Block Control All Form Types Use text block controls to display free-form HTML text and plain text elements.
Text Search Control Browse Portlet

Edit Portlet

Find/Browse

Header Detail

Headerless Detail

Parent/Child Browse

Power Edit

Power Browse

Reusable Browse Subform

Reusable Edit Subform

Search & Select

Wizard (page only)

 Use text search controls to enable full text searches against a generated index (as opposed to searching against the underlying BV).
Tree Control All Form Types Use tree controls to display a tree structure.
Wizard Wizard (default control) Use wizard controls to create self-directed applications. This specialized control is available only on wizard forms.

3.2 Understanding Form Control Design-Time Considerations

Some control property values are common to all controls, although many are shared by just a few. This table lists the property values for all control types. The descriptions given in some cases are for general use only. If a particular property significantly impacts a given form type, then those impacts are discussed in detail in the chapter devoted to that control. In addition to the standard controls you can add to a form using the Insert menu in FDA, this table includes grid columns which have their own property values separate from the grid itself and the standard menu properties such as OK, Save, Cancel, and so forth because they can act as push button controls. They are referred to as buttons in this table; for example, Select button.

Property Control Description
Allow Image Items Media Object An option to permit image items in the media object.
Allow OLE Items Media Object An option to permit OLE objects in the media object.
Allow RTF Text Media Object An option to permit RTF text to be included in the media object.
Allow Text Items Media Object An option to permit plain text objects in the media object. The plain text in the file is stored in the database.
Allowed in Saved Query Edit

Grid column

Saved Query Control

 An option to enable users to include the control as a filter value for a saved query. The property is available for entry only when a BV item is associated with the control.
Alternate Grid Row Format String Grid An HTML string that provides values for formatting the grid differently from the default system grid formatting. The system uses this string only if the Use Alternate Grid Row Format property is selected. You can also choose the formatting at runtime with the Set Grid Row Format system function. Set it to <DEFAULT> to use the system grid formatting and <ALTERNATE> to use this HTML string instead. The system function can switch between formats regardless of whether Use Alternate Grid Row Format is enabled.
Always Hidden Parent Child An option to hide the grid portion of the control.
Automatic Scroll Horizontal Edit A property that indicates whether the user can see text that exceeds the width of the field. If you permit scrolling, you can choose to have the system automatically scroll ten characters to the right when the user types text, or you can display a horizontal scroll bar.
Automatic Scroll Vertical Edit A property that indicates whether the user can see text that exceeds the height of the field when the Lines property is set to Multiple. If you permit scrolling, you can choose to have the system automatically scroll down a page when the user presses Enter, or you can display a vertical scroll bar.
Automatically Find on Entry Grid

Parent Child

 An option to cause runtime to populate the grid automatically when the form is entered.
Business View Name Grid

Parent Child

Subform

Subform Alias

 A property that indicates the BV underlying the control. In all cases except one, the BV for the control is the same as the one for the form. On a header detail form, the grid control may have a BV that is different than the one underlying the controls that comprise the header.
Button Type Push Button A property that indicates the button type: OK, Cancel, Yes, No, and so forth. For form types except Message, the only option is Other.
Calendar Day View Visible Calendar An option to enable users to access the view of the calendar that shows a single day at a time.
Calendar Month View Visible Calendar An option to enable users to access the view of the calendar that shows an entire month at once.
Calendar Week View Visible Calendar An option to enable users to access the view of the calendar that shows an entire week at once.
Checked Value Check Box

Grid column

 A property that is the value that the control returns when a user selects the control. The property applies to a grid column only when its Display Style property is set to Check Box.
Clickable Grid column

Icon grid column

Image

Static Text

 An option to cause runtime to fire the Text Clicked event when the user clicks the control.
Client Edge Group Box An option to give the group box the appearance of depth.
Collapsable Subform

Subform Alias

Group Box (Release 9.1 Update 3)

 An option to enable users to hide the content of the subform or group box (Release 9.1 Update 3), displaying only its header.
Column Header One Grid column A property that shows the text to be displayed in the first line of the column heading.
Column Header Two Grid column A property that shows the text to be displayed in the second line of the column heading.
Column Moved to Tree Parent Child A property that enables you to control which columns appear in the tree portion of the control.
Column Order Grid

Parent Child

 A property that controls the order in which the grid columns appear in the grid, from left to right in English.
Column Sort Order Grid

Parent Child

 A property that controls the order in which data returned to the grid is ordered for display.
Control ID All control types A property that shows the system ID of the current control. It cannot be changed.
Data Item Information Check Box

Combo Box

Edit

Grid column

Radio Button

Static Text

 A property that shows the DD item or BV column associated with the control. BV column choices come from the BV associated with the form.
Data Structure Subform

Subform Alias

 A property that shows the data structure being used to pass data between parent and child. If no data structure is attached to the form, the property is unavailable for entry.
Default cursor on add mode Edit

Grid column

Media Object

 An option to designate this field as the one in which the cursor appears initially when the form appears in Add mode. You can select this option for only one edit control on any given form.
Default cursor on update mode Edit

Grid column

Media Object

 An option to designate this field as the one in which the cursor appears initially when the form appears in Update mode. You can select this option for only one edit control on any given form.
Disable Copy Parent Child An option to prevent users from using the copy function in a cut/copy/paste operation.
Disable Drag and Drop (Cut/Copy/Paste) Parent Child An option to prevent users from using the cut/copy/paste function.
Disable Move (Cut) Parent Child An option to prevent users from using the move/cut function in a cut/copy/paste operation.
Disable Page-at-a-Time Process Grid

Parent Child

 An option to disable page-at-a-time processing. Page-at-a-time processing enables the runtime engine to fetch a single page of data only on the initial search call. If the user pages down, then runtime fetches only enough data to fill the next page. When disabled, runtime fetches and loads into memory all of the data at once. The number of rows that constitute a page of data is based on the Grid Row Count property.
Disable QBE Grid column An option to disable the QBE cell above a given column.
Disabled Calendar

Check Box

Close button

Combo Box

Delete button

Edit

Find button

Grid

Grid column

Group Box

Media Object

OK button

Parent Child

Push Button

Radio Button

Saved Query Control

Select button

Static Text

Subform

Subform Alias

Text Search Control

 An option to disable the control, preventing user interaction with it (although it can still be seen). You can also enable and disable controls during runtime with the Enable Control and Disable Control system functions.
Display Customized Grid Grid An option to enable users the option to customize the grid through grid formats.
Display Export to Excel Grid An option to enable users the option to send the contents of the control to an Excel spreadsheet.
Display Export to Word Grid An option to enable users the option to send the contents of the control to a Microsoft Word file.
Display Import from Excel Grid An option to enable users the option to bring the contents of an Excel spreadsheet into the control.
Display Style Grid column An option to make cells in the column act (and appear) as check boxes.
Do Not Clear After Add Edit

Grid column

 An option to retain the data in the field after runtime performs an add function. After performing an add, runtime usually clears all form fields.
Editable Subform

Subform Alias

 A property that indicates whether the subform type can be edited. Reusable edit subforms can be edited, reusable browse subforms cannot. Embedded subforms are editable or not based on their context within the parent form.
Expand All/Collapse All Parent Child An option to provide a button for the user to expand or collapse the entire tree.
Fetch on Form/Subform Businessview Subform

Subform Alias

 An option to cause the system to perform fetches from the subform business view. This option is disabled unless you have attached a BV to the subform.
File Name Image A property that displays the name of the image file to be displayed in the control.
Filter Criteria Edit

Radio Button

 A property that indicates whether the control value should be incorporated into the database fetch. If you want to use the value, then you must also choose the relational operator by which the value should be evaluated. In some cases, you can designate that the relational value should be chosen by the user at runtime instead.
Filter Criteria - Checked Filter Check Box A property that indicates whether the control should be incorporated in the database fetch as a filter criteria when the check box is selected. If you want to use this control as a filter, then you must also define how the filter value will be used by providing a relational operator or designate that the relational value should be set by the user at runtime instead.
Filter Criteria - Unchecked Filter Check Box A property that indicates whether the control should be incorporated in the database fetch as a filter criteria when the check box is cleared. If you want to use this control as a filter, then you must also define how the filter value will be used by providing a relational operator or designate that the relational value should be set by the user at runtime instead.
Flat Group Box An option to give the group box border the appearance of height.
Form Name Subform

Subform Alias

 A property that shows the system name for the subform. FDA names the subform based on JD Edwards EnterpriseOne naming standards (subforms start with S), the application name, and the creation sequence (the first subform is appended with an A, the second with a B, and so forth). You cannot change this property.
Full File Name Image A property that displays the name and location of the image file to be displayed in the control.
Grid Row Count Grid A property that shows the number of rows in a grid that constitute a "page."
Height Calendar

Check Box

Close button

Combo Box

Delete button

Edit

Find button

Grid

Group Box

Image

Media Object

OK button

Parent Child

Push Button

Radio Button

Saved Query Control

Select button

Static Text

Subform

Tab Control

Text Box Control

Text Search Control

Tree Control

Wizard

 A property that shows the height of the control in dialog units. You can change the height by typing a different value.
Hide HTML Row Selector Grid An option to hide the row selector when the form is viewed in HTML. You might choose to hide the selector either because it is not needed or because you want to prevent users from selecting entire rows.
Hide in Grid Parent Child A property that controls whether the designated tree column should be hidden in the grid. You should set this property to prevent the same column being displayed in two places, both in the tree and the grid.
Hide Query By Example Grid

Parent Child

 An option to hide the query-by-example (QBE) line above the grid. You might choose to hide the QBE either because it is not needed or because you want to prevent the users from defining query criteria on grid columns.
Indent and Outdent Parent Child An option to enable the user to change the horizontal position of a node in the tree.
Justification Check Box

Edit

Radio Button

Static Text

 A property that indicates whether the text of the control will be left-, center-, or right-justified.
Key Relations Parent Child A property that defines the values to use for certain key fields when the system builds queries. When you map a child key to a parent key, then the system sets the value of the parent variable equal to the associated child value for purposes of filtering the query.
Left Calendar

Check Box

Close button

Combo Box

Delete button

Edit

Find button

Grid

Group Box

Image

Media Object

OK button

Parent Child

Push Button

Radio Button

Saved Query Control

Select button

Static Text

Subform

Subform Alias

Tab Control

Text Box Control

Text Search Control

Tree Control

 A property that shows the distance from the left edge of the form to the left edge of the control in dialog units. You can change the horizontal placement of the control by typing a different value.
Lines Edit An option to enable the field to display multiple lines of text. If you select this option, usually you also set the Automatic Scroll View property such that users can view the text if it exceeds the height of the control.
Load Text by Instance Subform Alias An option that defines how jargon will be loaded for reusable subforms. If selected, the system fetches jargon based on the form that is using the subform. If cleared, the system fetches jargon based on the application where the subform is defined.
Location Indicator Feature Parent Child An option to enable or disable location indicator functionality for the parent child control. If selected, the system enables the user to choose to display a location indicator for each tree node.
Maintain Aspect Ratio Image An option to maintain the original width-to-height ratio when the image is resized.
Mapping Links Subform

Subform Alias

 A property that shows the mapping of data between a parent and its child forms. You must define this mapping to pass data between parent and child forms.
Menubar Separator Close button

Delete button

Find button

OK button

Select button

 An option to display a line above the name of the control when viewed in a menu list.
Modal Frame Group Box An option to give the group box the appearance of height.
Move Up and Down Parent Child An option to enable the user to change the vertical position of a node in the tree.
Multi-Line Edit Grid An option to post rows in groups of three to five to the database in the background. When disabled, in low interactivity mode, runtime posts each time the user tabs out of the row, forcing the user to wait for a refresh before continuing. This option does not apply to high interactivity.
Multiple Select Grid

Parent Child

 An option to enable users to select multiple lines to affect with a single operation, such as cut-and-paste.
New Text Item on Open Media Object An option to cause the control to create a new text item automatically when the user first opens the control.
No Adds On Update Grid Grid

Parent Child

 An option to prevent users from adding new records to the control. Users can still edit existing rows, however.
No display if currency is OFF Check Box

Edit

Grid column

Radio Button

Static Text

 An option to hide the control if currency is disabled.
Node ID Column Parent Child An option to use this column as a unique identifier for that row. The system functions, Insert Grid Buffer Row By Node ID and Get Related Node ID, require a node ID column to work correctly.
Number of columns joined to header Grid

Parent Child

 A property that enables backwards compatibility of certain legacy applications.

Note: Set this property value to zero for new applications.
Overrides Button Check Box

Combo Box

Edit

Grid column

Radio Button

 A button to set DD overrides for the control.
Parent Subform

Subform Alias

 A property that indicates the form that acts as the parent to the current subform.
Password Edit An option to cause the system to display an asterisk in place of the character the user actually typed. This feature is most often used to help protect passwords.
Prevent Resizing Image An option to prevent the image from being resized during design time.
Position of Saved Query links Saved Query Control A property that indicates where the saved query links appear relative to the main body of the control itself.
Process All Rows in Grid Grid An option to cause runtime to apply row changed and row exited logic to all rows, no matter their state.
Product Synch Mapping Parent Child A property that indicates how the data in the column will be used if the parent child control on which the grid resides has the Product Synch Mode property enabled.
Product Synch Mode Parent Child An option to use the control for process mapping applications (that is, rapid manufacturing).
Progress Indicator Wizard An option to display a progress indicator during runtime. You must also indicate its type, if the indicator is displayed.
Read Only Edit

Media Object

 An option to prevent users from changing the value in the control.
Reclaim Whitespace Grid An option to cause runtime to shrink the control vertically so it displays only those rows which contain data (HTML only).
Re-entry Save Wizard An option to enable users to save their input, quit, and then re-launch the wizard later, starting at the point where they saved.
Required field Combo Box

Edit

Grid column

 An option to force users to enter a value into this control before being able to execute a form-level action such as OK or Save (except Cancel). Runtime displays an asterisk next to the required field label, if control and label are connected.
Reusable Subform

Subform Alias

 A property that indicates whether the subform is reusable. Subforms that were created independently of a parent (such as, reusable browse subform and reusable edit subform) are reusable and may be referenced by an alias on any number of power forms. Subforms that were created as a control on a parent form cannot be referenced with an alias and are therefore not reusable.
Show DD Alias Tooltip I con grid column An option to display the Data Dictionary alias for the data item that an icon represents in the tooltip for that icon.
Show DD Name Tooltip Icon grid column An option to display the Data Dictionary name for the data item that an icon represents in the tooltip for that icon.
Show details of all tree nodes Parent Child An option to display one tree node for each grid row.
Show Header Subform

Subform Alias

 An option to display the header of the subform during runtime.
Show Icon Tooltip Icon grid column An option to display the descriptive text for the data item that an icon represents in the tooltip for that icon.
Show Value Tooltip Icon grid column An option to display the value of the data item that an icon represents in the tooltip for that icon.
Sort Order Grid column A property that displays the order in which column data will be sorted (ascending or descending).
Sortable by End User Grid column An option to enable the user to reorder the grid contents based on this column.
Sorted Combo Box An option to sort the items in the drop-down box alphabetically.
Static Edge Group Box An option to give the group box border the appearance of depth.
Subform Application Name Subform Alias A property that shows the name of the application that contains the reusable subform to which the alias points.
Support Multiple Currencies Grid column An option to enable the column to handle and display amounts in differing currency types.
Suppress Validation and Save Wizard An option to prevent runtime from validating and saving the data in the control.
Tab Stop Calendar

Check Box

Combo Box

Edit

Grid

Group Box

Media Object

Parent/Child

Push Button

Radio Button

Saved Query Control

Static Text

Text Search Control

 An option to enable users to press Tab to move the focus to the control.
Task List Wizard An option to display the task list during runtime.
Text is Overridden Check Box

Combo Box

Edit

Grid column

Radio Button

Static Text

 If the control is associated with a BV column or DD item, an option to change the title (the text that users can see) in this instance.
Title Calendar

Check Box

Combo Box

Edit

Grid

Group Box

Image

Media Object

Parent Child

Push Button

Radio Button

Saved Query Control

Static Text

Subform

Tab Control

Tab Page

Text Block Control

Text Search Control

Tree Control

Wizard

 A property that shows the text that the user can see. If the control is associated with a particular BV column or DD item, then you might need to select an overrides option to enable the field if you want to change its displayed text in a given instance.
Tool Tip Image A property that shows the text that appears in the tool tip for the image. The tool tip is the text that appears when the user hovers over the object.
Toolbar Close button

Delete button

Find button

OK button

Select button

 An option to display the control as a button on the standard application tool bar.
Toolbar Separator Close button

Delete button

Find button

OK button

Select button

 An option to display a line to the left of the control button when it appears on the standard application tool bar.
Top Calendar

Check Box

Close button

Combo Box

Delete button

Edit

Find button

Grid

Group Box

Image

Media Object

OK button

Parent Child

Push Button

Radio Button

Saved Query Control

Select button

Static Text

Subform

Subform Alias

Tab Control

Text Search Control

Text Box Control

Tree Control

 A property that shows the distance from the top edge of the form to the top edge of the control in dialog units. You can change the vertical placement of the control by typing a different value.
Transaction Subform An option to cause runtime to commit all changes at one time instead of individually. If the subform makes a single database change or a group of unrelated changes, do not select Transaction. However, if the subform has a group of inserts that rely on each other and if the system should revert to the previously committed changes if a change fails or for another condition, then select Transaction.
Unchecked Value Check Box

Grid column

 A property that is the value that the control returns when a user clears the control. The property applies to a grid column only when its Display Style property is set to Check Box.
Update Mapping Link Push Button An option to cause the parent to push data to its child before runtime performs any button processing.
Update Mode Grid An option to make the grid input-capable. Runtime implements this option only when the grid resides on input-type forms such as fix/inspect or header detail.
Update on Form/Subform Businessview Subform An option to cause the system to update the tables underlying the subform (except those underlying the grid control) during runtime when the user clicks the OK button. If you want greater control over subform updates, clear this option. This option is unavailable for entry unless you have attached a BV to the subform.
Use Alternate Grid Row Format Grid An option to use the HTML string in the Alternate Grid Row Format property to format the grid instead of using the default system formatting for grids.
UTC Display Format Edit

Grid control

 A property that controls how to display time and date fields. This property value is available for entry if the BV column or DD item associated with the control has a type of U-Time. This type of data represents date and time in Coordinated Universal Time (UTC) format. The offset is from Greenwich Mean.

This field is not a mask. Whatever format you select comprises the only data that is saved to the database. Therefore, if you select a format that displays only the date and not the time, then only the date is written to the database.
Value Radio Button A property that is the value that the control returns when a user selects the control.
Visible Calendar

Check Box

Combo Box

Edit

Grid

Grid column

Group Box

Image

Media Object

Parent Child

Push Button

Radio Button

Saved Query Control

Static Text

Subform

Subform Alias

Tab Control

Text Box Control

Text Search Control

Tree Control

Wizard

 An option to enable users to see the control. You can also hide and show the control during runtime with the system functions, Hide Control and Show Control.
Width Calendar

Check Box

Close button

Combo Box

Delete button

Edit

Find button

Grid

Grid column

Group Box

Image

Media Object

OK button

Parent Child

Push Button

Radio Button

Saved Query Control

Select button

Static Text

Subform

Tab Control

Text Box Control

Text Search Control

Tree Control

Wizard

 A property that shows the width of the control in dialog units. You can change the width by typing a different value.
Wildcard Edit At option to enable users to use the asterisk character as a wildcard when performing searches.
Wrap Text Grid column An option to enable text to wrap if it exceeds the column width. Otherwise, the system truncates column text.

3.3 Understanding Chart Control

This section provides an overview of the Chart Control.

3.3.1 Using the Chart Control

Use the Chart Control to set properties on a visible chart. These charts help plant managers quickly quantify the state of operations at a plant. FDA provides a set of system functions specific for the Chart Control. The chart Control uses the following files:

  • Data XML

    The data XML file determines the information that a graph displays. The Chart Control uses a data XML file that you create to call system functions. You can create the data XML file using any editor, such as business functions or event rules. Data XML is required for the Chart Control. See Appendix: A for examples of data XML.

  • Graph XML

    The graph XML file determines how the information that a graph displays is formatted, i.e. in a bar or pie format. JD Edwards provides default templates of graph xml files for you to use to design your charts. You can change or modify the information in the graph XML to change the appearance of the chart. The graph XML file is optional for the Chart Control. If the graph XML file is not specified for the Chart Control, then the graph will be displayed in the format specified by the graph name attribute in the data XML file. See Appendix: B for examples of graph XML.

FDA enables you to create the following chart types:

  • bar_basic

  • combo_basic

  • combo_markers

  • ine_basic

  • pie_basic

  • pie_onetime

  • stacked_bar_basic

  • stacked_bar_ontime

3.3.2 Using XML Graph Access

To quickly view how your chart will look, you can use the Direct XML Graph Access application located at the following

URL: http://<web server host>:<web server port>/jde/GraphPrototype.maf

The Direct XML Graph Access contains a sample of every chart JD Edwards EnterpriseOne provides. It contains an example DTD and data XML for each chart that you can edit to see immediately how your changes will impact the chart. You can also enter your own DTD and data XML to review a chart you have created.

You must use your EnterpriseOne login credentials to access the Direct XML Graph Access application.

3.3.3 System Functions for Charting

The following table contains the system functions EnterpriseOne created for the charting control.

System Function Description
Draw Chart(Chart Control) Call this system function to render a chart. Assume its DataXML is correctly populated. After calling other system functions to set chart properties, be sure to call this system function to show the new result. Otherwise, the new properties will not be shown on the form.
Set Data XML(Chart Control, data) Call this system function to set DataXML for the chart. Runtime will automatically read graphName from DataXML and set it to GraphName on this chart. The data XML is required to be set for a chart control. Otherwise an error is displayed.
Set Graph XML(Chart Control, graphXML) Call this system function to set customized graphXML for the chart. If this function is called, its graphXML will be used instead of graphName from the DataXML.
Set Graph Template(Chart Control, graphTemplate) Call this system function to set graphName for the chart. Runtime will read the checked in graph.xml based on the graphName.
Set Title(Chart Control, title) Call this system function to set the title for this chart.
Set Title Visible(Chart Control, true/false) Call this system function to make the title visible or invisible for this chart.
Set Footnote(Chart Control, footnote) Call this system function to set a footnote for the chart.
Set Footnote Visible(Chart Control, true/false) Call this system function to make a footnote visible or invisible for the chart.
Set Legend Orientation(Chart Control, Orientation) Call this system function to set the orientation for this chart. Valid values for Orientation are <Vertical> or <Horizontal>.
Set Legend Position(Chart Control, position) Call this system function to set the position for the chart. Valid values for Position are <Top>,<Left>,<Right>, or <Bottom>.
Set Legend Visible(Chart Control, true/false) Call this system function to make the legend visible or invisible for the chart.
Reset(Chart Control) Call this system function to reset all properties, but leave DataXML,graphXML and graphName unchanged.
Get Last Chart Click Event(rowIndex, columnIndex) Call this system function at the beginning of the "Chart is Clicked" FDA event. Tools will return the actual row and column index of the element clicked in the output ER variables. Application development can then use these ER variable values to execute any subsequent logic in the "Chart is Clicked" FDA event.
Turn Off Chart Clicked Event(Chart Control) Call this system function to disable clickable events on this chart. The default is to have clickable events be disabled.
Turn On Chart Clicked Event(Chart Control) Call this system function to enable clickable events on this chart. The default is to have clickable events be disabled.

3.3.4 C Code System Functions

The following table contains the C code system functions that applications call within C business functions to set chart properties in the web client.

System Functions Description
JDE_SetDataXML(lpBhvrCom, int chartId, JCHAR * dataXml) Call this system function to set DataXML for this chart.
JDE_SetGraphXML(lpBhvrCom, int chartId, JCHAR * graphXml) Call this system function to set customized graphXML for this chart.
JDE_DrawChart(lpBhvrCom, int chartId) Call this system function to render a chart. Assume its DataXML is correctly populated. to show the new result. Otherwise, the new properties won't be shown on the form.

C side system functions do not exist for the title, footnote, legend, and chart click properties.

3.3.5 Example Data XML

This section contains example data XML for each of the chart type provided in EnterpriseOne. You can modify the code in these data XMLs to alter what information is displayed on the chart.

The graph name attribute in the data XMLs below relates directly to the graph XML types in section Example Graph XMLs. All of the graph types share a common DTD, which is described in section Example Graph DTD.

bar_basic.xml

<Graph graphName="bar_basic">
<O1Title text="Week Ending" visible="true" /> 
<Y1Title text="Cost Variance (USD)" visible="true" /> 
<LocalRelationalData>
<Row columnKey="9/1/05" rowKey="Actual Variance" dataValue="1504" /> 
<Row columnKey="9/8/05" rowKey="Actual Variance" dataValue="980" /> 
<Row columnKey="9/15/05" rowKey="Actual Variance" dataValue="-675" /> 
<Row columnKey="9/22/05" rowKey="Actual Variance" dataValue="784" /> 
<Row columnKey="9/29/05" rowKey="Actual Variance" dataValue="0" /> 
<Row columnKey="9/1/06" rowKey="Actual Variance" dataValue="1504" /> 
<Row columnKey="9/8/06" rowKey="Actual Variance" dataValue="980" /> 
<Row columnKey="9/15/06" rowKey="Actual Variance" dataValue="-675" /> 
<Row columnKey="9/22/06" rowKey="Actual Variance" dataValue="784" /> 
<Row columnKey="9/29/06" rowKey="Actual Variance" dataValue="0" /> 
</LocalRelationalData>
</Graph>

combo_basic

<Graph graphName="combo_basic">
<O1Title text="Week Ending" visible="true" />
<Y1Title text="Days" visible="true" />
<LocalRelationalData>
<Row columnKey="1-Sept 05" rowKey="Actual DSI" dataValue="38" /> 
<Row columnKey="8-Sept 05" rowKey="Actual DSI" dataValue="25" /> 
<Row columnKey="15-Sept 05" rowKey="Actual DSI" dataValue="24" /> 
<Row columnKey="22-Sept 05" rowKey="Actual DSI" dataValue="27" />
<Row columnKey="1-Sept 05" rowKey="Target DSI" dataValue="10" /> 
<Row columnKey="8-Sept 05" rowKey="Target DSI" dataValue="10" /> 
<Row columnKey="15-Sept 05" rowKey="Target DSI" dataValue="10" /> 
<Row columnKey="22-Sept 05" rowKey="Target DSI" dataValue="10" />   </Local⇒
RelationalData>
</Graph>

combo_markers.xml

<Graph graphName="combo_markers">
<O1Title text="Week Ending" visible="true" /> 
<Y1Title text="Days" visible="true" /> 
<LocalRelationalData>
<Row columnKey="1-Sept 05" rowKey="Actual DSI" dataValue="38" /> 
<Row columnKey="8-Sept 05" rowKey="Actual DSI" dataValue="25" /> 
<Row columnKey="15-Sept 05" rowKey="Actual DSI" dataValue="24" /> 
<Row columnKey="22-Sept 05" rowKey="Actual DSI" dataValue="27" /> 
        LocalRelationalData>
</Graph>

line_basic.xml

<Graph graphName="line_basic">
 <O1Title text="Week Ending" visible="true" /> 
 <Y1Title text="Cost Variance (USD)" visible="true" /> 
<LocalRelationalData>
<Row columnKey="9/1/05" rowKey="Actual Variance" dataValue="1504" /> 
<Row columnKey="9/8/05" rowKey="Actual Variance" dataValue="980" /> 
<Row columnKey="9/15/05" rowKey="Actual Variance" dataValue="-675" /> 
<Row columnKey="9/22/05" rowKey="Actual Variance" dataValue="784" /> 
<Row columnKey="9/29/05" rowKey="Actual Variance" dataValue="0" /> 
<Row columnKey="9/1/06" rowKey="Actual Variance" dataValue="1504" /> 
<Row columnKey="9/8/06" rowKey="Actual Variance" dataValue="980" /> 
<Row columnKey="9/15/06" rowKey="Actual Variance" dataValue="-675" /> 
<Row columnKey="9/22/06" rowKey="Actual Variance" dataValue="784" /> 
<Row columnKey="9/29/06" rowKey="Actual Variance" dataValue="0" />
</LocalRelationalData>
</Graph>

pie_basic.xml

<Graph graphName="pie_basic">
<LocalRelationalData>
<Row columnKey="January 2005" rowKey="On Time" dataValue=".11" /> 
<Row columnKey="January 2005" rowKey="Early" dataValue=".21" /> 
<Row columnKey="January 2005" rowKey="Late" dataValue=".05" /> 
<Row columnKey="January 2005" rowKey="Past" dataValue=".12" /> 
<Row columnKey="January 2005" rowKey="History" dataValue=".25" /> 
<Row columnKey="January 2005" rowKey="Now" dataValue=".03" /> 
<Row columnKey="January 2005" rowKey="Then" dataValue=".14" /> 
<Row columnKey="January 2005" rowKey="When" dataValue=".09" /> 
</LocalRelationalData>
</Graph>

pie_ontime.xml

<Graph graphName="pie_ontime">
<LocalRelationalData>
<Row columnKey="January 2005" rowKey="On Time" dataValue=".11" /> 
<Row columnKey="January 2005" rowKey="Early" dataValue=".21" /> 
<Row columnKey="January 2005" rowKey="Late" dataValue=".05" />
</LocalRelationalData>
</Graph>

stacked_bar_basic.xml

<Graph graphName="stacked_bar_basic">
<O1Title text="Week Ending" visible="true" /> 
<Y1Title text="On Time Production" visible="true" /> 
<LocalRelationalData>
<Row columnKey="9/1/05" rowKey="On Time" dataValue="95" /> 
<Row columnKey="9/8/05" rowKey="On Time" dataValue="8" /> 
<Row columnKey="9/15/05" rowKey="On Time" dataValue="9.2" /> 
<Row columnKey="9/22/05" rowKey="On Time" dataValue="70" /> 
<Row columnKey="9/1/05" rowKey="Early" dataValue="1" /> 
<Row columnKey="9/8/05" rowKey="Early" dataValue="10" /> 
<Row columnKey="9/15/05" rowKey="Early" dataValue="40" /> 
<Row columnKey="9/22/05" rowKey="Early" dataValue="18" /> 
<Row columnKey="9/1/05" rowKey="Late" dataValue="0" /> 
<Row columnKey="9/8/05" rowKey="Late" dataValue="15" /> 
<Row columnKey="9/15/05" rowKey="Late" dataValue="4" /> 
<Row columnKey="9/22/05" rowKey="Late" dataValue="50" />
</LocalRelationalData>
</Graph>

stacked_bar_ontime.xml

<Graph graphName="stacked_bar_ontime">
<O1Title text="Week Ending" visible="true" /> 
<Y1ReferenceLine>
<ReferenceLine index="0" visible="true" text="Goal" value="95.0" /> 
</Y1ReferenceLine>
<Y1Title text="On Time Production" visible="true" /> 
<LocalRelationalData>
<Row columnKey="9/1/05" rowKey="On Time" dataValue=".90" /> 
<Row columnKey="9/8/05" rowKey="On Time" dataValue=".85" /> 
<Row columnKey="9/15/05" rowKey="On Time" dataValue=".92" /> 
<Row columnKey="9/22/05" rowKey="On Time" dataValue=".72" /> 
<Row columnKey="9/1/05" rowKey="Early" dataValue=".10" /> 
<Row columnKey="9/8/05" rowKey="Early" dataValue=".10" /> 
<Row columnKey="9/15/05" rowKey="Early" dataValue=".04" /> 
<Row columnKey="9/22/05" rowKey="Early" dataValue=".18" /> 
<Row columnKey="9/1/05" rowKey="Late" dataValue="0" /> 
<Row columnKey="9/8/05" rowKey="Late" dataValue=".05" /> 
<Row columnKey="9/15/05" rowKey="Late" dataValue=".04" /> 
<Row columnKey="9/22/05" rowKey="Late" dataValue=".10" /> 
</LocalRelationalData>
</Graph>

3.3.6 Example Graph XMLs

This section contains example graph XML for each of the chart type provided in EnterpriseOne. You can modify the code in these graph XMLs to alter how the chart displays information.

bar_basic.xml

<?xml version="1.0" ?>
<Graph version="3.2.0.22" autoLayout="AL_ALWAYS" markerTooltipType="MTT_VALUES"⇒
 graphicAntialiasing="true" textAntialiasing="true" seriesEffect="SE_AUTO_⇒
GRADIENT" frameSizeAutomatic="false">
<Background fillColor="#f1f6f0" />
<Footnote horizontalAlignment="RIGHT">
<GraphFont name="SansSerif" size="9" bold="false" italic="false" underline="false"⇒
 />  </Footnote>
<LegendArea visible="true" automaticPlacement="AP_NEVER" position="LAP_TOP" fill⇒
Color="#ffffff" />
<LegendText horizontalAlignment="LEFT">
<GraphFont name="SansSerif" size="9" bold="false" italic="false" underline="false"⇒
 /> </LegendText>
<O1TickLabel textRotation="TR_HORIZ" horizontalAlignment="RIGHT" tickLabel⇒
Staggered="false" tickLabelSkipMode="TLS_AUTOMATIC" tickLabelSkipCount="0" tick⇒
LabelSkipFirst="0" automaticRotation="AR_HORIZ_ROTATE_270">
<GraphFont name="SansSerif" size="9" bold="false" italic="false" underline="false"⇒
 />  </O1TickLabel>
<O1Title>
<GraphFont name="SansSerif" size="11" bold="true" italic="false" underline="false"⇒
 />  </O1Title>
<SeriesItems defaultColor="" />
<X1Title wordWrapEnabled="false" />
<Y1MajorTick visible="true" />
<Y1TickLabel horizontalAlignment="RIGHT">
<GraphFont name="SansSerif" size="9" bold="false" italic="false" underline="false"⇒
 /> </Y1TickLabel>
<Y1Title>
<GraphFont name="SansSerif" size="11" bold="true" italic="false" underline="false"⇒
 />  </Y1Title>
<Y2TickLabel horizontalAlignment="RIGHT" />
<Y2Title wordWrapEnabled="false" />
<Y1ReferenceLine>
<ReferenceLine index="0" lineWidth="2" displayedInLegend="true" lineColor=⇒
"#ff0000" /> </Y1ReferenceLine>
</Graph>

combo_basic.xml

<?xml version="1.0" ?> 
<Graph version="3.2.0.22" seriesTooltipLabelType="TLT_NONE" groupTooltipLabelType=⇒
"TLT_NONE" markerTooltipType="MTT_VALUES" markerDisplayed="true" markerShape⇒
InLegend="true" graphicAntialiasing="true" textAntialiasing="true" seriesEffect=⇒
"SE_AUTO_GRADIENT" frameSizeAutomatic="false">
<Background fillColor="#f1f6f0" /> 
<Footnote horizontalAlignment="RIGHT">
<GraphFont name="SansSerif" size="9" bold="false" italic="false" underline="false"⇒
 /> 
  </Footnote>
 <LegendArea visible="true" automaticPlacement="AP_NEVER" position="LAP_TOP" fill⇒
Color="#ffffff" /> 
<LegendText horizontalAlignment="LEFT">
<GraphFont name="SansSerif" size="9" bold="false" italic="false" underline="false"⇒
 />
</LegendText>
<O1TickLabel textRotation="TR_HORIZ" tickLabelSkipMode="TLS_AUTOMATIC" tickLabel⇒
SkipCount="0" tickLabelSkipFirst="0" automaticRotation="AR_HORIZ_ROTATE_270">
<GraphFont name="SansSerif" size="9" bold="false" italic="false" underline="false"⇒
 />
</O1TickLabel>
<O1Title>
<GraphFont name="SansSerif" size="11" bold="true" italic="false" underline="false"⇒
 />
</O1Title>
<SeriesItems defaultMarkerShape="MS_NONE" defaultFitlineType="FT_NONE">
<Series id="0" markerType="MT_BAR" /> 
<Series id="1" markerType="MT_MARKER" markerShape="MS_DIAMOND" lineWidth="2" color=⇒
⇒
⇒
⇒
⇒
⇒
⇒
⇒
⇒
⇒
⇒
"#ff0000" /> 
<Series id="2" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="3" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="4" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="5" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="6" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="7" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="8" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="9" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="10" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="11" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="12" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="13" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="14" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="15" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="16" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="17" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="18" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="19" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="20" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="21" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="22" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="23" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="24" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="25" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="26" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="27" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="28" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="29" markerType="MT_MARKER" markerShape="MS_DIAMOND" />
</SeriesItems>
<Y1MajorTick visible="true" /> 
<Y1TickLabel>
<GraphFont name="SansSerif" size="9" bold="false" italic="false" underline="false"⇒
 />
</Y1TickLabel>
<Y1Title>
<GraphFont name="SansSerif" size="11" bold="true" italic="false" underline="false"⇒
 />
</Y1Title>
<Y2MajorTick visible="true" /> 
<Y1ReferenceLine>
<ReferenceLine index="0" lineWidth="2" lineColor="#ff0000" displayedInLegend=⇒
"false" /> 
  </Y1ReferenceLine>
  </Graph>

combo_markers.xml

<?xml version="1.0" ?> 
<Graph version="3.2.0.22" seriesTooltipLabelType="TLT_NONE" groupTooltipLabelType=⇒
"TLT_NONE" markerTooltipType="MTT_VALUES" markerDisplayed="true" markerShape⇒
InLegend="true" graphicAntialiasing="true" textAntialiasing="true" seriesEffect=⇒
"SE_AUTO_GRADIENT" frameSizeAutomatic="false">
<Background fillColor="#f1f6f0" /> 
<Footnote horizontalAlignment="RIGHT">
<GraphFont name="SansSerif" size="9" bold="false" italic="false" underline="false"⇒
 />
</Footnote>
<LegendArea visible="true" automaticPlacement="AP_NEVER" position="LAP_TOP" fill⇒
Color="#ffffff"/>
<LegendText horizontalAlignment="LEFT">
<GraphFont name="SansSerif" size="9" bold="false" italic="false" underline="false"⇒
 />
</LegendText>
<O1TickLabel textRotation="TR_HORIZ" tickLabelSkipMode="TLS_AUTOMATIC" tickLabel⇒
SkipCount="0" tickLabelSkipFirst="0" automaticRotation="AR_HORIZ_ROTATE_270">
<GraphFont name="SansSerif" size="9" bold="false" italic="false" underline="false"⇒
 />
</O1TickLabel>
<O1Title>
<GraphFont name="SansSerif" size="11" bold="true" italic="false" underline="false"⇒
 /> 
</O1Title>
<SeriesItems defaultMarkerShape="MS_NONE" defaultFitlineType="FT_NONE">
<Series id="0" markerType="MT_BAR" /> 
<Series id="1" markerType="MT_MARKER" markerShape="MS_DIAMOND" lineWidth="2" color=⇒
⇒
⇒
⇒
⇒
⇒
⇒
⇒
⇒
⇒
⇒
"#ff0000" /> 
<Series id="2" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="3" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="4" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="5" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="6" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="7" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="8" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="9" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="10" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="11" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="12" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="13" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="14" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="15" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="16" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="17" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="18" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="19" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="20" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="21" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="22" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="23" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="24" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="25" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="26" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="27" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="28" markerType="MT_MARKER" markerShape="MS_DIAMOND" /> 
<Series id="29" markerType="MT_MARKER" markerShape="MS_DIAMOND" />
</SeriesItems>
<Y1MajorTick visible="true" /> 
<Y1TickLabel>
<GraphFont name="SansSerif" size="9" bold="false" italic="false" underline="false"⇒
 /
</Y1TickLabel>
<Y1Title>
<GraphFont name="SansSerif" size="11" bold="true" italic="false" underline="false"⇒
 />
</Y1Title>
<Y2MajorTick visible="true" /> 
<Y1ReferenceLine>
<ReferenceLine index="0" lineWidth="2" lineColor="#ff0000" displayedInLegend=⇒
"false" />
</Y1ReferenceLine>
</Graph>

line_basic.xml

<?xml version="1.0" ?> 
<Graph version="3.2.0.22" graphType="LINE_VERT_ABS" depthAngle="0" legendScrollbar⇒
Presence="SP_NEVER" legendSeriesCount="0" graphicAntialiasing="true" text⇒
Antialiasing="true" markerShapeInLegend="true" frameSizeAutomatic="false">
<Background fillColor="#f1f6f0" /> 
<Footnote horizontalAlignment="RIGHT">
<GraphFont name="SansSerif" size="9" bold="false" italic="false" underline="false"⇒
 />
</Footnote>
<LegendArea visible="true" automaticPlacement="AP_NEVER" position="LAP_TOP" fill⇒
Color="#ffffff"/> 
<LegendText horizontalAlignment="LEFT">
<GraphFont name="SansSerif" size="9" bold="false" italic="false" underline="false"⇒
 />
</LegendText>
<O1TickLabel textRotation="TR_HORIZ" tickLabelSkipMode="TLS_AUTOMATIC" tickLabel⇒
SkipCount="0" tickLabelSkipFirst="0" automaticRotation="AR_HORIZ_ROTATE_270">
<GraphFont name="SansSerif" size="9" bold="false" italic="false" underline="false"⇒
 />
</O1TickLabel>
<O1Title>
<GraphFont name="SansSerif" size="11" bold="true" italic="false" underline="false"⇒
 />
</O1Title>
<Y1MajorTick visible="true" /> 
<Y1TickLabel>
<GraphFont name="SansSerif" size="9" bold="false" italic="false" underline="false"⇒
 />
</Y1TickLabel>
<Y1Title>
<GraphFont name="SansSerif" size="11" bold="true" italic="false" underline="false"⇒
 />
</Y1Title>
<Y2MajorTick visible="true" />
</Graph>

pie_basic.xml

<?xml version="1.0" ?> 
<Graph version="3.2.0.22" autoLayout="AL_ALWAYS" depthAngle="50" depthRadius="0"⇒
 pieDepth="0" groupTooltipLabelType="TLT_NONE" graphicAntialiasing="true" text⇒
Antialiasing="true" pieTilt="0" seriesEffect="SE_AUTO_GRADIENT" graphType="PIE">
<Background fillColor="#f1f6f0" /> 
<Footnote horizontalAlignment="RIGHT">
<GraphFont name="SansSerif" size="9" bold="false" italic="false" underline="false"⇒
 />
</Footnote>
<LegendArea visible="false" /> 
<LegendText horizontalAlignment="CENTER" /> 
<O1TickLabel textRotation="TR_HORIZ" tickLabelSkipMode="TLS_NOSKIP" automatic⇒
Rotation="AR_NO_ROTATE" /> 
<O1Title wordWrapEnabled="false" /> 
<PlotArea fillColor="#f1f6f0" /> 
<PieLabel>
<GraphFont name="SansSerif" size="11" bold="true" italic="false" underline="false"⇒
 />
</PieLabel>
<Slice labelPosition="LP_OUTSIDE_WITH_FEELER" /> 
<SliceLabel textType="LD_TEXT_PERCENT">
<GraphFont name="SansSerif" size="9" bold="false" italic="false" underline="false"⇒
 />
</SliceLabel>
<X1Title wordWrapEnabled="false" /> 
<Y1TickLabel horizontalAlignment="RIGHT" /> 
<Y1Title wordWrapEnabled="false" /> 
<Y2TickLabel horizontalAlignment="RIGHT" /> 
<Y2Title wordWrapEnabled="false" />
</Graph>

pie_onetime.xml

<?xml version="1.0" ?> 
<Graph version="3.2.0.22" autoLayout="AL_ALWAYS" depthAngle="50" depthRadius="0"⇒
 pieDepth="0" groupTooltipLabelType="TLT_NONE" graphicAntialiasing="true" text⇒
Antialiasing="true" pieTilt="0" seriesEffect="SE_AUTO_GRADIENT" graphType="PIE">
<Background fillColor="#f1f6f0" /> 
<Footnote horizontalAlignment="RIGHT">
<GraphFont name="SansSerif" size="9" bold="false" italic="false" underline="false"⇒
 />
</Footnote>
<LegendArea visible="false" /> 
<LegendText horizontalAlignment="CENTER" /> 
<O1TickLabel textRotation="TR_HORIZ" tickLabelSkipMode="TLS_NOSKIP" automatic⇒
Rotation="AR_NO_ROTATE" /> 
<O1Title wordWrapEnabled="false" /> 
<PlotArea fillColor="#f1f6f0" /> 
<PieLabel>
<GraphFont name="SansSerif" size="11" bold="true" italic="false" underline="false"⇒
 />
</PieLabel>
<SeriesItems>
<Series id="0" color="#336699" /> 
<Series id="1" color="#ffff00" /> 
<Series id="2" color="#ff0000" />
</SeriesItems>
<Slice labelPosition="LP_OUTSIDE_WITH_FEELER" /> 
<SliceLabel textType="LD_TEXT_PERCENT">
<GraphFont name="SansSerif" size="9" bold="false" italic="false" underline="false"⇒
 />
</SliceLabel>
<X1Title wordWrapEnabled="false" /> 
<Y1TickLabel horizontalAlignment="RIGHT" /> 
<Y1Title wordWrapEnabled="false" /> 
<Y2TickLabel horizontalAlignment="RIGHT" /> 
<Y2Title wordWrapEnabled="false" />
</Graph>

stacked_bar_basic.xml

<?xml version="1.0" ?> 
<Graph version="3.2.0.22" seriesTooltipLabelType="TLT_NONE" groupTooltipLabelType=⇒
"TLT_NONE" markerTooltipType="MTT_VALUES" graphicAntialiasing="true" text⇒
Antialiasing="true" seriesEffect="SE_AUTO_GRADIENT" graphType="BAR_VERT_STACK">
<Background fillColor="#f1f6f0" />
<Footnote horizontalAlignment="RIGHT">
<GraphFont name="SansSerif" size="9" bold="false" italic="false" underline="false"⇒
 />
</Footnote>
<LegendArea automaticPlacement="AP_NEVER" position="LAP_TOP" fillColor="#ffffff" ⇒
/> <LegendText horizontalAlignment="LEFT">
<GraphFont name="SansSerif" size="9" bold="false" italic="false" underline="false"⇒
 />
</LegendText>
<O1TickLabel textRotation="TR_HORIZ" tickLabelSkipMode="TLS_AUTOMATIC" tickLabel⇒
SkipCount="0" tickLabelSkipFirst="0" automaticRotation="AR_HORIZ_ROTATE_270">
<GraphFont name="SansSerif" size="9" bold="false" italic="false" underline="false"⇒
 />
</O1TickLabel>
<O1Title>
<GraphFont name="SansSerif" size="11" bold="true" italic="false" underline="false"⇒
 />
</O1Title>
<Y1ReferenceLine>
<ReferenceLine index="0" lineWidth="2" lineColor="#ff0000" displayedInLegend=⇒
"true" />
</Y1ReferenceLine>
<Y1TickLabel>
<GraphFont name="SansSerif" size="9" bold="false" italic="false" underline="false"⇒
 />
</Y1TickLabel>
<Y1Title>
<GraphFont name="SansSerif" size="11" bold="true" italic="false" underline="false"⇒
 />
</Y1Title>
</Graph>

stacked_bar_ontime.xml

<?xml version="1.0" ?> 

<Graph version="3.2.0.22" seriesTooltipLabelType="TLT_NONE" groupTooltipLabelType=⇒
"TLT_NONE" markerTooltipType="MTT_PERCENT_VAL" graphicAntialiasing="true"⇒
 textAntialiasing="true" seriesEffect="SE_AUTO_GRADIENT" graphType="BAR_VERT_⇒
PERCENT">

<Background fillColor="#f1f6f0" /> 
<Footnote horizontalAlignment="RIGHT">
<GraphFont name="SansSerif" size="9" bold="false" italic="false" underline="false"⇒
 />
</Footnote>
<LegendArea automaticPlacement="AP_NEVER" position="LAP_TOP" fillColor="#ffffff" ⇒
/> 
<LegendText horizontalAlignment="LEFT">
<GraphFont name="SansSerif" size="9" bold="false" italic="false" underline="false"⇒
 />
</LegendText>
<O1TickLabel textRotation="TR_HORIZ" tickLabelSkipMode="TLS_AUTOMATIC" tickLabel⇒
SkipCount="0" tickLabelSkipFirst="0" automaticRotation="AR_HORIZ_ROTATE_270">
<GraphFont name="SansSerif" size="9" bold="false" italic="false" underline="false"⇒
 />
</O1TickLabel>
<O1Title>
<GraphFont name="SansSerif" size="11" bold="true" italic="false" underline="false"⇒
 />
</O1Title>
<SeriesItems>
<Series id="0" color="#336699" /> 
<Series id="1" color="#ffff00" /> 
<Series id="2" color="#ff0000" />
</SeriesItems>
<Y1ReferenceLine>
<ReferenceLine index="0" lineWidth="2" lineColor="#ff0000" displayedInLegend=⇒
"true" />
</Y1ReferenceLine>
<Y1TickLabel>
<GraphFont name="SansSerif" size="9" bold="false" italic="false" underline="false"⇒
 />
</Y1TickLabel>
<Y1Title>
<GraphFont name="SansSerif" size="11" bold="true" italic="false" underline="false"⇒
 />
</Y1Title>
</Graph>

3.3.7 Example Graph DTD

This section contains example graph DTD for each of the chart type provided in EnterpriseOne. You can modify the code in these graph DTDs to alter how the chart displays information.

<?xml version='1.0' encoding="UTF-8"?>

<!ELEMENT Graph
(Footnote?,MarkerText?,O1Title?,Title?,Subtitle?,X1Axis?,Y1Axis?,Y1Reference⇒
Line?,Y1Title?,Y2Axis?,Y2Title?,LocalRelationalData)
<!--the graphName is the name of a pre-defined tempate to use-->
<!ATTLIST Graph
   graphName CDATA #REQUIRED
<!-- Graph definition of the footnote -->
<!ELEMENT Footnote EMPTY>
<!ATTLIST Footnote
    text CDATA #IMPLIED
    visible (true | false) #IMPLIED
<!ELEMENT MarkerText (GraphFont?, X1ViewFormat?, Y1ViewFormat?, Y2ViewFormat?,  ⇒
 ZViewFormat?) >
<!-- MarkerText attributes:
    markerTextPlace: where, in relation to the marker, the marker text appears;
       outside max is above bar
       on max edge is sitting on the bar
       inside max is on the bar, near the top
       inside min is on the bar, near the bottom
       center is centered on the bar
       custom lets you set the angle and radius
    **next to attributes in effect only when markerTextPlace is MTP_CUSTOM**
    markerTextAngleDefault: angle of the text, in degrees, measured from the
       center of the marker
    markerTextRadiusDefault: distance from the center of the marker, 0 - 100
-->
<!ATTLIST MarkerText
    visible (true | false) #IMPLIED
    fontSizeAbsolute (true | false) #IMPLIED
    markerTextPlace (MTP_OUTSIDE_MAX | MTP_ON_MAXEDGE | MTP_INSIDE_MAX |
                     MTP_INSIDE_MIN | MTP_CENTER | MTP_CUSTOM) #IMPLIED
    markerTextAngleDefault CDATA #IMPLIED
    markerTextRadiusDefault CDATA #IMPLIED >

<!-- Title for the ordinal axis (O1Axis)-->
<!ELEMENT O1Title EMPTY>
<!ATTLIST O1Title
    text CDATA #IMPLIED
    visible (true | false) #IMPLIED
>
<!-- Graph definition of the title; appears in graph image -->
<!ELEMENT Title EMPTY>
<!ATTLIST Title
    text CDATA #IMPLIED
    visible (true | false) #IMPLIED
>
<!-- Graph definition of the subtitle; appears in graph image -->
<!ELEMENT Subtitle EMPTY>
<!ATTLIST Subtitle
    text CDATA #IMPLIED
    visible (true | false) #IMPLIED
>
<!-- Reference line for Y1-axis: includes up to 3 actual lines -->
<!ELEMENT Y1ReferenceLine (ReferenceLine*) >

<!-- Represents the actual line in ReferenceLine element -->
<!ELEMENT ReferenceLine EMPTY >

<!-- ReferenceLine attributes:
    index: which line in this axis; 0, 1, or 2
    text: description of reference line
    value: where along the axis the line should appear
    displayedInLegend: whether a key to the line appears in the legend
-->
<!ATTLIST ReferenceLine
    index CDATA #REQUIRED
    visible (true | false) #IMPLIED
    lineWidth CDATA #IMPLIED
    text CDATA #IMPLIED
    value CDATA #IMPLIED
    displayedInLegend (true | false) #IMPLIED
    lineColor CDATA #IMPLIED
    lineStyle (LS_SOLID | LS_DASH | LS_DOTTED | LS_DASH_DOT) #IMPLIED >
<!-- Title for the Y1-axis (left side); reads up -->
<!ELEMENT Y1Title EMPTY>
<!ATTLIST Y1Title
    text CDATA #IMPLIED
    visible (true | false) #IMPLIED
>

<!-- Title for the Y2-axis (right side); reads down -->
<!ELEMENT Y2Title EMPTY>
<!ATTLIST Y2Title
    text CDATA #IMPLIED
    visible (true | false) #IMPLIED
>
<!-- Relational data for local data source:
     Graph builds a grid of data from this element and children -->
<!ELEMENT LocalRelationalData
   (Row+)
>
<!ELEMENT Row EMPTY>
<!ATTLIST Row
columnKey CDATA #IMPLIED
dataValue CDATA #IMPLIED
rowKey CDATA #IMPLIED
>
<!-- ViewFormat specifies number formatting-->
   <!ELEMENT ViewFormat EMPTY >
   <!-- ViewFormat attributes
   numberType: format numbers as currency or percent?
   thousandSeparator: character for separating thousands
   decimalSeparator: character for separating whole number from decimal
   currencySymbol: currency symbol; numberType must be NUMTYPE_CURRENCY
   leadingZero: display leading zeros?
   decimalDigit: number of decimal digits to display
   posNumFmt: format for positive numbers
   negNumFmt: format for negative numbers
   posCurFmt: format for positive currency
   negCurFmt: format for negative currency
   scaleFactor: how much to scale (abbreviate) numbers
   scaleDownThousands: character(s) to use when numbers represent thousands
   scaleDownMillions: character(s) to use when numbers represent millions
   scaleDownBillions: character(s) to use when numbers represent billions
   scaleDownTrillions: character(s) to use when numbers represent trillions
   scaleDownQuadrillions: character(s) to use when numbers represent
           quadrillions
   javaDateFormat: Java date format
   oracleDateFormat: Oracle date format

 "used" attributes specify whether one of the above properties has
   been explicitly set; used for merging when using rules
   -->
   <!ATTLIST ViewFormat
   numberType (NUMTYPE_GENERAL | NUMTYPE_CURRENCY | NUMTYPE_PERCENT) #IMPLIED
   thousandSeparator CDATA #IMPLIED
   decimalSeparator CDATA #IMPLIED
   currencySymbol CDATA #IMPLIED
   leadingZero (true | false) #IMPLIED
   decimalDigit CDATA #IMPLIED
   posNumFmt (POS_NUMFMT_NUM | POS_NUMFMT_POS_NUM | POS_NUMFMT_NUM_POS ) #IMPLIED
   negNumFmt (NEG_NUMFMT_OP_NUM_CP | NEG_NUMFMT_NEG_NUM | NEG_NUMFMT_NUM_NEG)⇒
 #IMPLIED
   posCurFmt (POS_CURFMT_CUR_NUM | POS_CURFMT_NUM_CUR |
                   POS_CURFMT_CUR_SPAC_NUM |POS_CURFMT_NUM_SPAC_CUR |
                   POS_CURFMT_POS_CUR_NUM | POS_CURFMT_CUR_NUM_POS |
                   POS_CURFMT_POS_NUM_CUR | POS_CURFMT_NUM_POS_CUR |
                   POS_CURFMT_NUM_CUR_POS | POS_CURFMT_POS_NUM_SPAC_CUR |
                   POS_CURFMT_POS_CUR_SPAC_NUM | POS_CURFMT_NUM_SPAC_CUR_POS )
   #IMPLIED
   negCurFmt (NEG_CURFMT_OP_CUR_NUM_CP | NEG_CURFMT_NEG_CUR_NUM |
                   NEG_CURFMT_CUR_NEG_NUM | NEG_CURFMT_CUR_NUM_NEG |
                   NEG_CURFMT_OP_NUM_CUR_CP | NEG_CURFMT_NEG_NUM_CUR |
                   NEG_CURFMT_NUM_NEG_CUR | NEG_CURFMT_NUM_CUR_NEG |
                   NEG_CURFMT_NEG_NUM_SPAC_CUR | NEG_CURFMT_NEG_CUR_SPAC_NUM |
                   NEG_CURFMT_NUM_SPAC_CUR_NEG ) #IMPLIED
   scaleFactor (SCALEFACTOR_NONE | SCALEFACTOR_THOUSANDS |
                   SCALEFACTOR_MILLIONS | SCALEFACTOR_BILLIONS |
                   SCALEFACTOR_TRILLIONS | SCALEFACTOR_QUADRILLIONS ) #IMPLIED
   scaleDownThousands CDATA #IMPLIED
   scaleDownMillions CDATA #IMPLIED
   scaleDownBillions CDATA #IMPLIED
   scaleDownTrillions CDATA #IMPLIED
   scaleDownQuadrillions CDATA #IMPLIED
   javaDateFormat CDATA #IMPLIED
   oracleDateFormat CDATA #IMPLIED
   numberTypeUsed (true | false) #IMPLIED
   thousandSeparatorUsed (true | false) #IMPLIED
   decimalSeparatorUsed (true | false) #IMPLIED
   currencySymbolUsed (true | false) #IMPLIED
   leadingZeroUsed (true | false) #IMPLIED
   decimalDigitUsed (true | false) #IMPLIED
   posNumFmtUsed (true | false) #IMPLIED
   negNumFmtUsed (true | false) #IMPLIED
   posCurFmtUsed (true | false) #IMPLIED
   negCurFmtUsed (true | false) #IMPLIED
   scaleFactorUsed (true | false) #IMPLIED
   scaleDownThousandsUsed (true | false) #IMPLIED
   scaleDownMillionsUsed (true | false) #IMPLIED
   scaleDownBillionsUsed (true | false) #IMPLIED
   scaleDownTrillionsUsed (true | false) #IMPLIED
   scaleDownQuadrillionsUsed (true | false) #IMPLIED
   javaDateFormatUsed (true | false) #IMPLIED
   oracleDateFormatUsed (true | false) #IMPLIED >
   
<!-- ViewFormats for different number values that can appear in marker
     text and tooltip text -->
<!ELEMENT X1Axis (ViewFormat?) >
<!ELEMENT X1ViewFormat (ViewFormat) >
<!ELEMENT Y1Axis (ViewFormat?) >
<!ELEMENT Y1ViewFormat (ViewFormat) >
<!ELEMENT Y2Axis (ViewFormat?) >
<!ELEMENT Y2ViewFormat (ViewFormat) >
<!ELEMENT ZViewFormat (ViewFormat) >

3.4 Attaching Data Items to a Control

This section provides an overview of the relationship between data items and controls and discusses how to:

  • Attach a data item to a control.

  • Override a default DD trigger.

3.4.1 Understanding the Relationship between Data Dictionary Items and Controls

On a form, you can use any data item that is in the BV and any data item from the DD. BV items are associated with the database; they are retrieved from and updated to the database tables. DD items are not connected to the database; their values are not retrieved from nor updated to the database tables by the system. On a form, BV items appear with a blue box in the left corner, and DD items appear with a yellow box in the left corner. Use DD items as work fields for ER or fields that are not directly connected to the database table.

You can associate data item values with these control types:

  • Check boxes.

  • Edit controls.

  • Grid controls (columns).

  • Parent child controls (columns).

  • Radio buttons.

    Radio buttons must be associated with DD items. All radio buttons with the same DD item are considered to be a group. Selecting one radio button within the group automatically clears all other radio buttons in the same group.

  • Combo boxes

The rest of the controls types either cannot be associated with a data item, such as push buttons, or essentially act as containers for controls, such as subforms and tab pages, which may in turn be associated with a data item, according to their type.

If you want the user-entered value for a control to update a database record, then the control must be associated with a BV item. For example, a check box can be associated with the database field called Taxable. In the check box properties, the Checked value should be Y and the Unchecked value should be N. You can use these values in ER as well.

Each DD item has a set of properties (such as Default Value) and behaviors (such as Format Rules and Edit Rules). When you create a DD item, you define its default properties and behaviors at that time. You can override previously-defined DD items at the application level, which enables you to further customize how data items behave at runtime. You can disable default properties and behaviors for a specific item, as well as override to use different values and triggers.

3.4.2 Attaching a Data Item to a Control

To attach a data item to a control:

  1. Select the control, and then click Data Item Information in the Property Browser and click the ellipses button that appears in the Data Item Information field.

  2. On Control Properties, perform one of these tasks:

    • To attach a data item from the BV attached to the form, click the Business View Items tab and double-click a data item.

    • To attach a data item from the DD, click the Data Items tab, search for the data item you want, and then double-click it.

  3. To override the data item name as it appears on the form, click the General tab, click Override Text, and then enter the name you want to use in the Event Rules Title field.

    The Text is Overridden property in the Property Browser changes to Yes. To return the display name to the DD name, change Text is Overridden to No.

3.4.3 Overriding a Default Data Dictionary Trigger

To override default DD properties and triggers.

  1. On the form, double-click a control with an attached DD item.

  2. On Edit Properties, click the Overrides tab, and then click Data Dictionary Overrides.

  3. On Data Dictionary Overrides, to disable one or more triggers, select the ones you want to disable in the Disable box.

  4. To override a trigger, click the applicable trigger type and complete the form that appears.

    For example, if you click Default Value, the Override Default Value form appears and you would make your changes there.

3.5 Associating a Data Item Description with a Field

This section provides an overview of the relationship between data item descriptions and fields and discusses how to display the title of a data item associated with a field.

3.5.1 Understanding the Relationship between Data Item Descriptions and Fields

When you insert an edit control on the form and associate a data item with it, FDA does not automatically associate a description with the field. If you want to display the row description for the data item automatically on the form, you must associate the data item description with the field.

When you associate a description with an edit control, a description of the value in the control automatically appears next to it. Associating a description is optional but is useful as a visual aid on the form.

For example, suppose that the address book number, for example, 1001 appears in an edit control or in an edit control. When the user presses Tab to move out of the control, the address book name, XYZ Company, appears next to the control as the associated description.

3.5.2 Displaying the Title of a Data Item Associated with a Field

To display the title of a data item associated with a field:

  1. Click the control, and then select Edit, Associate Description.

    FDA creates a static text block and attaches it to the cursor so that you can place it where you want.

  2. Click the approximate location on the form where you want the description to appear.

3.6 Grouping Controls

Sometimes, you want a set of controls to be taken as a whole by the user. The classic example is when you want the user to select one item from a list of items, and this situation is typically resolved by creating a radio button for each option and then grouping them so that the user can select only one at a time.

To provide the user with a visual cue that the controls are grouped, you can place a group box around the controls. Use the Title property for the group box to label the group on the form.

If you want to create more space on a form or only display controls when needed, you can apply the Collapsable property. When the Collapsable property has been applied to the group box a title bar will appear. Clicking on the title bar will expand / collapse the group box. Once the Collapsable property is applied you can also use the Expand Group Box and Collapse Group Box Control System Functions within Event Rules. You can place a collapsable group box next to another (parallel) as long as the group box property Position -Top is the same value for both. (Release 9.1 Update 3)

3.7 Setting the Tab Sequence of Controls on a Form

This section provides an overview of tab sequences and discusses how to change the tab sequence on a form.

3.7.1 Understanding Tab Sequences

The tab sequence of the controls determines the order in which the cursor travels through the controls on the form. Each control that is designated as a tab stop is numbered to reflect how the cursor will travel. For example, when the user opens the form, the cursor appears on the control labeled number one. When the user presses Tab, the cursor moves sequentially to the control (tab stop) labeled number two on the form.

Only those controls that are designated as tab stops in the control properties are affected by the tab sequence. The default tab sequence is the order in which you place the controls on the form.

These properties can override the first tab stop:

  • Default cursor on add mode

  • Default cursor on update mode

3.7.2 Changing the Tab Sequence on a Form

To change the tab sequence:

  1. On the form with which you are working, select Layout, and then Tab Sequence.

    FDA displays each control so you see its number in the tab sequence instead of its name.

  2. Click the controls in the order in which you want the cursor to travel.

    The first control that you click becomes number one, the second becomes number two, and so on. To reset the numbers to their original values, right-click anywhere in the window.

    Note:

    Subforms contain their own sequence orders for objects on the subform. Therefore, you set the tab sequence on each subform within the subform itself. The subform, then, becomes a single object in the tab sequence for the power form.

  3. Click Layout , and then Tab Sequence again to stop selecting the sequence.

OR

  1. Click Layout, and then click Update Tab Sequence.

  2. Right-click on a control on which you want to change the tab sequence.

    The Tab Sequence field displays.

  3. Change the number in the field to reflect where you want that field in sequence to the other fields.

  4. Press Enter.

    FDA automatically adjusts the remaining fields in the sequence. For example, if you change a field sequence from 2 to 4 the remaining fields adjust as follows:

    Original Field Sequence Adjusted Field Sequence
    Field 1 Field 1
    Field 2 Field 4
    Field 3 Field 2
    Field 4 Field 3

3.8 JD Edwards EnterpriseOne FDA Compare

The FDA Compare tool in Form Design Aid (FDA) enables you to compare one version of an application to another. You can compare them on the application level to determine whether forms have been added, deleted, or rearranged and whether the properties have changed. You also can compare the forms in the applications to each other to see whether controls have been added, deleted, or rearranged and whether the properties have changed.

Additionally, you can compare two different applications as well. This feature is useful when you have made a new application by copying an existing one and then modifying it. Then, when you upgrade, you can not only compare the base application to its new counterpart, but also you can compare a custom application.

See "Understanding FDA Compare" in the JD Edwards EnterpriseOne Tools Software Updates Guide.