Page History
...
Expand | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Expand | ||||||
---|---|---|---|---|---|---|
| ||||||
|
Expand | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||
|
Expand | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
|
Expand | |||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||||
|
Display Format Types
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 |
...
title | Sorting |
---|
Option | Description |
---|---|
Direction | Apply sorting to an individual column. If you wish to use multiple fields to provide a sort order, see Table Sort. |
HTML |
---|
<iframe width="700" height="394" src="https://www.youtube.com/embed/8k3093theT0?color=white" frameborder="0" allowfullscreen></iframe> |
...
title | Data |
---|
Option | Description |
---|---|
Font Style | Define styling options for the text in this field. This covers the font face, font size, font colour, and font style. |
Alignment | Define the alignment option for text in this field. |
Background | Define a custom background colour for the column. |
Column Width | Define the width of the column. |
Maximum Length | Define the maximum number of characters to be displayed in the cell. |
Wrap Text | Wrap long cell text across multiple rows. |
...
title | Borders |
---|
...
Option
...
Description
...
Position
...
Define where borders should be displayed around the edges of the cell.
...
Colour
...
Define the colour of the cell borders.
...
Width
...
Define the thickness of the cell borders.
...
title | Summary |
---|
...
Option
...
Description
...
Total Aggregation
...
Define the aggregation to be applied to the column as a total.
Note: the calculated total is only available for calculated fields and will create a total based on the same rules as were used for the calculation. For example if you have a ratio of Received / Invoiced the total will equal the Sum (Received) / Sum (Invoiced)
...
Display Labels
...
Display a text label for the column summary.
...
Style
...
. |
...
Background
...
Define the background colour for the column summary.
...
Sub Total
...
Display a sub total row for each unique value in the column.
...
Select column fields from this list to hide their subtotal. Works for regular and cross-tab reports.
Tip: Remember to disable conditional formatting on subtotal cells if you’re opting to hide the subtotal values.
...
...
Column Drop Down Menu
Styleclass | ||
---|---|---|
| ||
...