Format Step

A Format Step is the last step in the workflow, and lists all fields provided by the Query Object. A Format Step includes these parameters:

Format Step Parameters
Property	Description
Field	Original name of field.
Source	Step in which this field originated.
Caption	The end user will see the field by this name.
Hyperlink	Drilldown detail or hyperlink URL.
Group Label	To assign this field to an existing group, select the group name from the drop-down list. To create a new group, type the new group name.
Hidden	If selected, the field will be invisible to users for the reporting process.
GIS Enabled	The selected field must contain GIS classification data such as country names, state, or city names. A GIS Enabled field will appear in the selection list for the grouping option in the GIS Mapping dialog and the Area field and the Heat Map Properties > Value fields on the Create Map dialog.
Format properties
Width	The default width of this field when dragged onto a report. Valid values 1-100.
Output Format	Enter a format string. The field value will be formatted using the format string. Useful for date and number formatting. (If you need to decide the format string at runtime, select Apply Locale Default.)
Align	Field alignment (left, center, right) when assigned to a report.
Input Format	Enter a format string. The string determines the prompting format for the value of this field in Ad hoc filters. Useful in prompting date or IP values in the desired format.
User Time Zone	Time zone for the display of report data. The Report Server calculates the difference between Database Time Zone and User Time Zone, and does time conversion. To decide time zone at runtime, select SYS_USER_TZ.

To define a Format Step:

From the Fields list, select the field for which you want to define an input format. (The selected field is bold.)
Select the appropriate format and provide necessary values for that format.

To designate a mandatory filtering field:

From the Fields list, select a field you want as a mandatory filtering field.

Click the Mandatory checkbox to the right of the Fields list.

Other fields can be selected or deselected using the Mandatory checkbox.