Chart Fields

1. In the Explorer Tree, locate the field that you wish to modify.

• Expand the Template Information object, locate the desired template and expand it.  Locate the block on which the field exists and expand it.  Select the field that you wish to modify and display the Property Sheet for it.

• Expand the Group Information object and any sub-groups until you can select the desired entity and expand it.  Locate the block on which the field exists and expand it.  Select the field that you wish to modify and display the Property Sheet for it.

2. Modify the field properties.  These will either be displayed in Alphabetical or Logically, depending on the setting of the [Sort Alphabetically/Logically] button.  The following instructions are assuming that the properties are sorted logically.

3. In the Name property, the name assigned to the field when it was created will be displayed.  It can be changed, if desired.

4. In the Description property, enter a user-defined description for this field.

5. In the Type pop-list, select the desired field type.  Choices are:

• Text: used to display text or for querying purposes on this chart.  

• Database Value: used with the database label, these are the measured values that determine the height of the bars, the point on the line, the size of the pie slice, etc.

• Database Label: only one of these is required per chart.  This is the column that is the key to the chart, for which the values are measured.  The values in this column are used to label each bar, each slice, each point on the line, etc.

6. In the From Database pop-list, select true if the field value will be taken from the database.  Select false if the field value will not be user-defined.  

• When set to true, the From Query, and From Column properties will be displayed.  All fields with this pop-list set to true obtain their values from the column defined in the From Column property and the query for the block defined in the From Query property.

• When set to false, the Contents property will be displayed.

7. In the Datapoint Label property, enter the label that will be displayed for this field value on the chart.

8. In the Size field, enter the character size for this field.  

9. In the From Query pop-list, verify that the correct query block is displayed in this field.  This is the block for which the database query is used to define the data displayed for this column.  Only database fields have this property.

10. In the From Column pop-list, verify that the correct column is displayed in this field.  This is the column selected in the query defined in the 'From Query' property from which the data for this field will be obtained.  The value in this field can be changed to another column from the same table/view.  Only database fields have this property.

11. Set the Visible pop-list to true if the field will be displayed on the page.  Select false if the field will be included on the page, but not displayed.

12. In the Hyperlink To property, enter the linking information for the field.  
    
    This is also where Database Function Calls and Links between Entities should be entered.  When possible, relative URL's should be entered (/xephr/show/entity) rather than absolute URL's (http://test1.ndsasp.com/xephr/show/entity).  

• HREF links and Javascript should always use single quotes ( ' ) instead of double quotes ( " ).

• During runtime, the status bar of the browser shows the actual HREF of the link being accessed. This HREF may not be what you wrote here in the property sheet, as this value will go through several transformations to handle "live" data. Most notably, $$BLOCK.FIELD$$ will be translated to what the browser is expecting to see in order to access the requested data. For Internet Explorer 6, this will be something like'"document.forms["BLOCK1"].elements["FIELD"].value '; for another system it could be something completely different.

13. If the Hyperlink To property contains an entry, in the Hyperlink Scripted pop-list, select true or  false.  
    
    When this pop-list is set to true, it indicates that the entry in the Hyperlink To property is a script.  If you entered a Database Function Calls or a Link between Entities, this pop-list should be set to true.  
    
    When this pop-list is set to false, it indicates that the entry in the Hyperlink To property is a direct link and not a script.

14. If the Hyperlink To property contains an entry and the Hyperlink Scripted property is set to false, in the Use New Window property, if the link in the Hyperlink To field needs to open in a new window, set this pop-list to true.  Otherwise, set the pop-list to false.

15. For chart fields on screens, in the On QBE pop-list, select true to include this field on the QBE page.  Select false to prevent the field from being displayed on the QBE page.
    
    When this pop-list is grayed out, it indicates that the On QBE pop-list has been set to false at the block level.  It must be set to true at the block level to be able to be changed here.  

16. For chart fields on screens, in the On New pop-list, select true to include this field on the New page.  Select false to prevent the field from being displayed on the New page.
    
    When this pop-list is grayed out, it indicates that the On New pop-list has been set to false at the block level.  It must be set to true at the block level to be able to be changed here.  

17. For chart fields on screens, in the On List pop-list, select true to include this field on the List page.  Select false to prevent the field from being displayed on the List page.
    
    When this pop-list is grayed out, it indicates that the On List pop-list has been set to false at the block level.  It must be set to true at the block level to be able to be changed here.  

18. For chart fields on screens, in the On Edit pop-list, select true to include this field on the Edit page.  Select false to prevent the field from being displayed on the Edit page.
    
    When this pop-list is grayed out, it indicates that the On Edit pop-list has been set to false at the block level.  It must be set to true at the block level to be able to be changed here.  

19. For chart fields on reports, in the Show On pop-list, select the pages on which this field will be displayed.  Choices are All Pages, First Page Only, and All but First.

20. In the Z Order property, enter the order in which the field will be displayed in comparison with the other fields on the block.  
    
    Z order affects fields when they overlap one another.  For example, if you had 2 fields of the same size in the same location on the block, one with a Z order of 10, and the other with a Z order of 20, the one with the Z order of 20 will be displayed because it was generated last.
    
    Z order also affects the order in which the fields are selected when tabbing through fields.  Generally, tabbing through the fields is ordered according to the order in which the fields were output for standard fields such as checkboxes, text fields, links, and might include images and labels depending on the browser .  A Z order of 1 indicates that the cursor should be placed in that field when the page is loaded.  Tabbing from that field will take the cursor to the next highest Z order.  If two fields are assigned the same Z order, their output order in relationship to each other is in effect random.  
    
    Different browsers may use a different tab order.  Depending on the browser, some field types may or may not be able to be accessed by tabbing, including links, images, and labels.

21. In the Created on property, the date and time on which the field was created is displayed and cannot be changed.

22. In the Modified on property, the date and time on which the field was last changed is displayed and cannot be modified.

23. When all changes have been made, press the [Save] button on the main toolbar.

Xephr is a registered trademark of NDS Systems, LC.

Copyright © 2007 NDS Systems LC.