Page History

...

1. By selecting the Create New Formula option the formula generation dialog will open.
2. The formula builder will allow you to generate a valid formula that will be returned by this column. Highlighted buttons will help guide you to create a valid formula.
   
3. Test your formula by clicking the test formula link.

Case Statements

...

1. Select the date format you want in your hierarchy and drag the field into an appropriate category.
   
2. Set up the meta data as normal
3. In the bottom of the tab, select the field parameter you want to base your field on. Some of the formats require a timestamp as input, so the list you can choose from will differ depending on the format.
4. Format your field as normal and save.

Expand
title Possible fields include (based on an SQL Server source connection):
Field Output Type Input Date Date Date or Date + Time Year Integer Date or Date + Time Month Integer Date or Date + Time Month Name Varchar Date or Date + Time Day of Month Integer Date or Date + Time Quarter Integer Date or Date + Time Week of Year Integer Date or Date + Time Day of Year Integer Date or Date + Time Day of Week Integer Date or Date + Time Day Name Varchar Date or Date + Time Hour Integer Time Minute Integer Time Second Integer Time Week Start Date Date Date or Date + Time Week End Date Date Date or Date + Time Month Start Date Date Date or Date + Time Month End Date Date Date or Date + Time Year Start Date Date Date or Date + Time Year End Date Date Date or Date + Time

See Drill Down Hierarchies for more information.

...

1. A common set of filters are used by report writers - such as location, or business unit; or
2. If there are particularly complex filters that can be built ahead of time and are commonly used.

Create New Filter

1. Filters can only be created using the formula builder. Like a standard calculated field select the filter options from the unattached fields list. Drag the filter option into the report folder list.
   
2. On dragging the field into your folder you will be presented with the filter formula builder.
3. Select the field you wish to filter and then use the operator, brackets, and or function buttons and text field to build your filter.
   
4. Click OK to save your filter and include it into your field list. The filter will be highlighted with a filter icon.

Filter Operands

...

...

When defining a filter initially set the operand drop down to the desired value. The options within the drop down will vary based upon the type of field that the filter is to be applied to.

...