you highlight a cell or group of cells within the Template Setup pane, the Properties
– Selected Cells pane becomes available.
This pane allows you to setup data and other properties for the
cell. You have a couple of options:
The cell can hold a constant value
The field can hold a text as well as include
data from the work order or trouble ticket
The field can contain a sum of the value of
You can design the appearance of the text
from bold, italic or underline.
2. The following options are
available within the Properties – Selected Cells pane:
Within this field, you can type text to
include within the cell. The text can
stand-alone or you can add information from the order/trouble or from anywhere
within cairs.net to the field as well.
Text that exceeds the length of the cell
will overflow into the cell to the right, if that cell does not contain any
other information. To keep the text
within the original cell, expand the column width.
This determines where the information from
the work order appears within the cell if you have entered text in the above
field. You have two options, before the
text or after the text.
! No delimiter is placed between the data and
the cell text. If you want to separate the data from the cell text, place the
desired delimiter before or after the text. For example, - Work Order Form. To
use a space as a delimiter between cell text and data press the space bar after
or before the cell text.
Important: It’s important to know that a cell cannot
display alpha numeric information simultaneously. If a cell contains text and
then has numerical data associated to it as explained in Selecting a Data
Category, Using Related Table Data and Using Related Field Data, the numerical
data is converted to text. So for example, if you have a cell with the text
Date, and want to display the report date, the best option is to associate an
adjacent cell so that the adjacent cell can display the date as a date instead
of as text.
This field determines where the information
you are entering into the field comes from, what table in cairs.net holds the
information. The following options are
o None – Use Related Table and Field – this
selection requires that you use the Related Table Date and the Related Field
Data dropdowns to populate the cell
The following selections remove the Related
Table Data and Related Field Data fields and replace them with a dropdown
specific to your selection.
* When the data source is the same for a group
of connected cells, you can save time by assigning properties such as a Data
Category to all of the cells at once by selecting a range of cells and then
setting the cell properties. The cells retain their assigned Data Category and
can then be assigned additional properties as needed.
o Report Information – this selection allows
you to insert some necessary report information such as page numbers, date,
o Work Order Custom Fields – this selection
pulls information from the custom fields associated to a work order
o Order Information – this selection pulls
information from the work order, for example, work order category, account
number, subscriber, etc.
o Connectivity – this selection pulls
information from the facilities section of the component
o Equipment and Services – this selection
pulls information from the equipment and services section of the component, for
example, equipment type, cost, location, etc.
o Set Management Component – this selection
pulls information from a set device
o Circuit Component - this selection pulls
information from a circuit
o Segment Component - this selection pulls information from a
o Non Switch Number Component – this selection
pulls information from any component that does not require a switch, for
example, a cell phone
o Account Management - this selection pulls
information from a account
you select None, the Related Data fields are removed and replaced with a field
name specific to your selection or Special Data Value.
Related Table Data & Related Field Data
When you select None in the Data Category
field these fields become available to allow you to associate information
outside the scope of the work order. For
example, if you select the Subscriber Component, the entire range of fields
relating to a subscriber becomes available within the Field Data. The following Related Tables are available:
o Work Order/Trouble
o Circuit Component
o Segment for Circuit Component
o Configured Set Component
o Non-Switch Directory Component
o Subscriber Component
o Account Component
o General Component
o Notes for Order/Trouble
* When the data source is the same for a group
of connected cells, you can save time by assigning properties such as Related
Field Data to all of the cells at once. The cells retain their assigned Related
Field Data and can then be assigned additional properties as needed.
Data Aggregate Option
This option allows you to have a total for
the cells that contain amounts. For
example, if you want to know the total charges for the equipment and services
associated to a work order, you would select the Sum directly below the last
equipment or service field. The
following options are available:
o Group By
o Combine in Cell
Use Multiply By to multiply a cell’s
contents by a specified number. For example, if a cell displays a total or
numerical data, by entering a number a 3 in this field, cairs.net multiplies
the contents by 3. The Multiply By field
can be used to show a percentage-based tax amount or fee related to a total, or
for any situation in which a numeric value needs to be multiplied by a fixed
Font Size, Font Bold, Italic or Underline
Use these options to
further customize the look of the information that appears in the selected
3. As you make changes to your
template, remember to click on the Save button within the Actions ribbon group
to save your changes and continue working with the template.