Upper & Lower Case

To alter the display of text in a data element returned from the data set in Initial Letter Capitalized style to ALL CAPS, use the Upper Case function in either the Query or Results section.

  1. In Query section, double click the intended item on the Request Line (or select item and select Modify) (In Results section, select Results menu, select Add Computed Item and name the new data item in the dialog box).
  2. Press the Functions… button on right in dialog box.
  3. Select String Functions from the Function List Categories window in the Database Functions dialog box.
  4. Select Upper from the Functions available in the window to the right.
  5. Confirm the referenced column name.
  6. Click OK in the Database Functions dialog box.
  7. Click OK in the Item dialog box.
  8. To review/modify the computed item double click on the item name on the Request Line.

To alter the display of text in a data element returned from the data set in ALL CAPS to Initial Letter Capitalized style, use the Initial Caps function in either the Query or Results section.

  1. In Query section, double click the intended item on the Request Line (or select item and select Modify) (In Results section, select Results menu, select Add Computed Item and name the new data item in the dialog box).
  2. Press the Functions… button on right in dialog box.
  3. Select String Functions from the Function List Categories window in the Database Functions dialog box.
  4. Select Initcap from the Functions available in the window to the right.
  5. Confirm the referenced column name.
  6. Click OK in the Database Functions dialog box.
  7. Click OK in the Item dialog box.
  8. To review/modify the computed item double click on the item name on the Request Line.

Last updated: October 15, 2013

Last updated: October 15, 2013