Fields

The Fields tab shows a table of the available fields from the datasource. The columns are described below:
Field The first column contains the name of the field in the datasource. This name is determined by the datasource and cannot be edited here.
Group The group that this field should be shown under in the left panel of the report tool. Groups can be added or removed using the Groups tab.
Display Name The Display Name is the name shown to users of the report tool. You can use a meaningful, unique name here which is more understandable than the often cryptic internal database field names.
Alignment Choose the alignment of this kind of field value. Usually strings should be left aligned, and numbers are often right-aligned.
Format Choose an appropriate format for numbers, dates and times here. Leave blank for strings.
Show Values Ticking this option means that the set of unique values of this field will be available for choosing in the Filter Expression Editor within the report tool. Note that this is meaningful for values where there is considerable duplication, eg. "Job Title" with values such as "Manager" or "Department Head" rather than for values like "Date Of Birth". When you want to choose a date you probably want a date chooser (provided by the report tool), rather than a list of known dates of birth! Sending a lot of values to the client can increase the initial loading time of the report, so by default the option is only enabled for fields with less than twenty unique values.