Working with Form Controls

This chapter provides an overview of Oracle's JD Edwards EnterpriseOne form controls and form control design-time considerations, and discusses how to use Oracle's JD Edwards EnterpriseOne Form Design Aid (FDA) to:

Attach data items to a control.
Associate a data item description with a field.
Group controls.
Set the tab sequence of controls on a form.

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.

A maximum of 250 controls can exist on a form. FDA warns you if you are near the 250-control limit. 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.

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.

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	An option to enable users to hide the content of the subform, 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.

Understanding Chart Control

This section provides an overview of the Chart Control.

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

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.

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.

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.

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" />   </LocalRelationalData>
</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>

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" fillColor="#ffffff" />
<LegendText horizontalAlignment="LEFT">
<GraphFont name="SansSerif" size="9" bold="false" italic="false" underline="false" /> </LegendText>
<O1TickLabel textRotation="TR_HORIZ" horizontalAlignment="RIGHT" tickLabelStaggered="false" tickLabelSkipMode="TLS_AUTOMATIC"
tickLabelSkipCount="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 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" markerShapeInLegend="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" fillColor="#ffffff" /> 
<LegendText horizontalAlignment="LEFT">
<GraphFont name="SansSerif" size="9" bold="false" italic="false" underline="false" />
</LegendText>
<O1TickLabel textRotation="TR_HORIZ" tickLabelSkipMode="TLS_AUTOMATIC" tickLabelSkipCount="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" markerShapeInLegend="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" fillColor="#ffffff"/>
<LegendText horizontalAlignment="LEFT">
<GraphFont name="SansSerif" size="9" bold="false" italic="false" underline="false" />
</LegendText>
<O1TickLabel textRotation="TR_HORIZ" tickLabelSkipMode="TLS_AUTOMATIC" tickLabelSkipCount="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" legendScrollbarPresence="SP_NEVER" legendSeriesCount="0"
graphicAntialiasing="true" textAntialiasing="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" fillColor="#ffffff"/> 
<LegendText horizontalAlignment="LEFT">
<GraphFont name="SansSerif" size="9" bold="false" italic="false" underline="false" />
</LegendText>
<O1TickLabel textRotation="TR_HORIZ" tickLabelSkipMode="TLS_AUTOMATIC" tickLabelSkipCount="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" textAntialiasing="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" automaticRotation="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" textAntialiasing="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" automaticRotation="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" textAntialiasing="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" tickLabelSkipCount="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" tickLabelSkipCount="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>

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?,Y1ReferenceLine?,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) >

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.

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.

Attaching a Data Item to a Control

To attach a data item to a control:

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.
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.
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.

Overriding a Default Data Dictionary Trigger

To override default DD properties and triggers.

On the form, double-click a control with an attached DD item.
On Edit Properties, click the Overrides tab, and then click Data Dictionary Overrides.
On Data Dictionary Overrides, to disable one or more triggers, select the ones you want to disable in the Disable box.
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.

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.

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.

Displaying the Title of a Data Item Associated with a Field

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

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.
Click the approximate location on the form where you want the description to appear.

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.

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.

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

Changing the Tab Sequence on a Form

To change the tab sequence:

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

FDA displays each control so you see its number in the tab sequence instead of its name.
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.