Overview
The Column format tab contains a number of sections that you can use to format you fields.
Each of these sections is described below.
Option
Description
Display
To change the display name of the column from the default value simply update this field.
Format
Each data type will have a unique set of format options - eg Text, Date or Numeric.
See Display Formats for details on each type.
Sub Format
Depending on the format option you have chosen for the column above you will have a separate set of sub format options. Select the appropriate sub format option.
Date Other
If you select 'Other' from the date sub format you will be able to build your own custom date format.
For example to create a Japanese date format which includes characters, eg. 2003?4?2?would be created by adding in: yyyy?M?d ?
Decimal Places
If you have a defined a numeric format you can set the number of decimal places to be defined. This can be used to define cents in a decimal place for $20.00 by adding in:2
Note: To convert numeric data by doing divide by 1,000 calculations etc you would use the data conversion options in advanced functions which are available on the Report Fields page.
See Advanced Functions for more information.
Prefix
The prefix is used to include additional characters before the value that is returned from the data base. This can be used to define currency for $20.00 by adding in: $
Suffix
The suffix is used to include additional characters after the value that is returned from the data base. This can be used to define percentage for 30% by adding in: %
Rounding
The rounding format allows you to choose how a decimal value should be rounded.
- Round Up: Will round any decimal up eg. 1.1 to 2
- Round Down: Will round any decimal down eg. 1.9 to 1
- Round Half Up: Rounds 0.5 and above up
- Round Half Down: Rounds 0.5 and below down
Thousand Separator
Turns the defaulted thousand separator for your instance on or off. For example:
1000 to 1,000
Bracket Negatives
Displays negative values with or without brackets.
Show Field
To hide the column from the report, select this item. By hiding a column the data presented on the page is not re-grouped which would occur if you removed the field from your report. For Example:
Original Report
City
Country
Sum Revenue
London
UK
500,000
Manchester
UK
300,000
Hamburg
Germany
400,000
Munich
Germany
450,000
City Column Hidden
Country
Sum
Revenue
UK
500,000
UK
300,000
Germany
400,000
Germany
450,000
City Column Removed From Report
Country
Sum Revenue
UK
800,000
Germany
850,000
Suppress Duplicates
The suppression of duplicate option will remove duplicate values from a column and group the values under a single value.
Display Formats
Based on the type of field that the column being formatted is there are various format options. The ones listed below come default with Yellowfin, however as this is customisable there may be additional ones that comes as part of your installation.
Format Option
Description
Text
Displays as plain text
Case Formatter
Allows you to format text as Uppercase or Lowercase.
Email
Creates a hyperlink on the text that will open an email client and pre-populate the sent to address.
Flag Formatter
If your data contains ISO country codes you can display these as flags of the world instead of text.
HTML
Formats a field containing HTML tags, either by removing them, or using them, depending on user selection. For example, if you wanted to display an image using a URL the field may look something like this:
<img src="http://imagepathhere.png" />
.
HTML 5 Video
Displays a video from a path stored in the field, either a full URL, or a relative path if the video is stored in the Yellowfin ROOT directory.
Link To URL
Allows you to pass the value of the returned data into a URL link.
Use the hashes ## to indicate to Yellowfin where you want the column value to be placed in the url itself.
For example: Formatting on a column of IP addresses and the url typed in is:
http://www.google.com.au/search?hl=en&q=##
This essentially means that every ip address will be placed into it into it i.e.:
http://www.google.com.au/search?hl=en&q=10.100.32.44
Org Ref Code
Converts the text in the cell to the value of an internal lookup table. E.g. AU to Australia. See Org Ref Codes for more information.
Raw Formatter
Displayed the data as it would have been returned from the database - no additional formatting applied.
URL Hyperlink
Creates a hyperlink on the text and will open web page on click. Assumes the text is a legitimate URL.
YouTube Formatter
This displays a YouTube video, based on the ID being stored in the field.
Date
Date
Displays value as a date - multiple date options exist.
Time
Displays value as a time field - multiple date options exist.
Timestamp
Displayed full date and time value
Date Part Formatter
Takes a date field and formats the display to show part of that date.
Numeric
Numeric
Displays value as a decimal - allows you to set the decimal places to be used.
Percentage Bar
Converts a percentage value less than or equal to 100 into a bar.
Option |
Description |
||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Display |
To change the display name of the column from the default value simply update this field. |
||||||||||||||||||||||||||||||||
Format |
Each data type will have a unique set of format options - eg Text, Date or Numeric.
|
||||||||||||||||||||||||||||||||
Sub Format |
Depending on the format option you have chosen for the column above you will have a separate set of sub format options. Select the appropriate sub format option. |
||||||||||||||||||||||||||||||||
Date Other |
If you select 'Other' from the date sub format you will be able to build your own custom date format. |
||||||||||||||||||||||||||||||||
Decimal Places |
If you have a defined a numeric format you can set the number of decimal places to be defined. This can be used to define cents in a decimal place for $20.00 by adding in:2
|
||||||||||||||||||||||||||||||||
Prefix |
The prefix is used to include additional characters before the value that is returned from the data base. This can be used to define currency for $20.00 by adding in: $ |
||||||||||||||||||||||||||||||||
Suffix |
The suffix is used to include additional characters after the value that is returned from the data base. This can be used to define percentage for 30% by adding in: % |
||||||||||||||||||||||||||||||||
Rounding |
The rounding format allows you to choose how a decimal value should be rounded.
|
||||||||||||||||||||||||||||||||
Thousand Separator |
Turns the defaulted thousand separator for your instance on or off. For example: |
||||||||||||||||||||||||||||||||
Bracket Negatives |
Displays negative values with or without brackets. |
||||||||||||||||||||||||||||||||
Show Field |
To hide the column from the report, select this item. By hiding a column the data presented on the page is not re-grouped which would occur if you removed the field from your report. For Example: Original Report
City Column Hidden
City Column Removed From Report
|
||||||||||||||||||||||||||||||||
Suppress Duplicates |
The suppression of duplicate option will remove duplicate values from a column and group the values under a single value. |
Display Formats
Based on the type of field that the column being formatted is there are various format options. The ones listed below come default with Yellowfin, however as this is customisable there may be additional ones that comes as part of your installation.
Format Option |
Description |
---|---|
Text |
Displays as plain text |
Case Formatter |
Allows you to format text as Uppercase or Lowercase. |
Creates a hyperlink on the text that will open an email client and pre-populate the sent to address. |
|
Flag Formatter |
If your data contains ISO country codes you can display these as flags of the world instead of text. |
HTML |
Formats a field containing HTML tags, either by removing them, or using them, depending on user selection. For example, if you wanted to display an image using a URL the field may look something like this: |
HTML 5 Video |
Displays a video from a path stored in the field, either a full URL, or a relative path if the video is stored in the Yellowfin ROOT directory. |
Link To URL |
Allows you to pass the value of the returned data into a URL link. This essentially means that every ip address will be placed into it into it i.e.: http://www.google.com.au/search?hl=en&q=10.100.32.44 |
Org Ref Code |
Converts the text in the cell to the value of an internal lookup table. E.g. AU to Australia. See Org Ref Codes for more information. |
Raw Formatter |
Displayed the data as it would have been returned from the database - no additional formatting applied. |
URL Hyperlink |
Creates a hyperlink on the text and will open web page on click. Assumes the text is a legitimate URL. |
YouTube Formatter |
This displays a YouTube video, based on the ID being stored in the field. |
|
Date |
Date |
Displays value as a date - multiple date options exist. |
Time |
Displays value as a time field - multiple date options exist. |
Timestamp |
Displayed full date and time value |
Date Part Formatter |
Takes a date field and formats the display to show part of that date. |
|
Numeric |
Numeric |
Displays value as a decimal - allows you to set the decimal places to be used. |
Percentage Bar |
Converts a percentage value less than or equal to 100 into a bar. |
Option
Description
Style
Define styling options for the table headers in this report. This covers the font face, font size, font colour, font style, and alignment.
**
Option |
Description |
---|---|
Style |
Define styling options for the table headers in this report. This covers the font face, font size, font colour, font style, and alignment. |
** |
Option
Description
**
Option |
Description |
---|---|
** |
Option
Description
**
Option |
Description |
---|---|
** |
Option
Description
**
Option |
Description |
---|---|
** |
Option
Description
**
Option |
Description |
---|---|
** |