On the Display tab, you specify the columns and calculated fields to expose through the Domain and how they appear. Typically, you select only columns that are useful in building or filtering reports, and omit other columns for simplicity. You can also modify display properties like the labels and descriptions of tables and sets and items for each specified column. Using meaningful labels and descriptions helps users.
The Display tab contains three panels:
| • | Resources – Here you can view resources as either a Join Tree or a Table List: |
| • | Join Tree – Displays joined, unjoined, and calculated tables for this Domain. Joined tables appear as join trees. |
| • | Table List – Displays the selected and calculated tables for this Domain. |
| • | Sets and Items – Lists resources that appear to report creators who use the Domain. |
| • | Properties – Displays and modifies properties of selected sets and item. |
In the Table List view, you can use the Delete Table button to remove the selected table from the Resources panel and from the Domain design. The table no longer appears on the Joins tab, and any joins to the table are deleted. Use carefully.
To specify which columns and calculated fields are exposed to users of the Domain, move them from the Resources panel to the Sets and Items panel:
| • | Set – A group of items independent of the tables in which the columns originate. |
| • | Item – A column or calculated field, along with its display properties, that you want to appear in the Domain. |
All items in a set correspond to columns in a join tree. Sets are optional. You can create a list of items outside of any sets. If you want to display only a few of the columns from the join tree, first create a new set in Sets and Items. Next, add items from the join tree in Resources.
To move a resource to Sets and Items, you can drag it from Resources and drop it in Sets and Items, or use one of the following buttons:
Add to Sets – Select a resource in Resources and click this icon to add it to Sets and Items. Tables are added as sets. Columns are added as items outside of any set.
Add to Selected Set – Select a destination set in Sets and Items, select a resource in Resources, and click this icon. Tables are added to Sets and Items as subsets. Columns are added as items within the destination set. You can also expand sets in Sets and Items and drag tables and columns from Resources to the destination set.
New Set – Creates a new subset of a selected set or a top-level set if no set is selected.
Delete – Removes the selected set or item. You can also double-click the object or drag and drop it in a blank area of Resources. Items removed from Sets and Items automatically reappear in Resources.
To move most of the tables and columns in Resources to Sets and Items:
| 1. | Double-click the join tree name in Resources, or drag-and-drop it from Resources to Sets and Items. All tables are created as sets, and columns are created as items within the sets. |
| 2. | Remove any unwanted sets or items individually from Sets and Items using the Delete Item button. |
To change the order of items within a set in Sets and Items:
| 2. | Reposition the item using one of the following buttons: |
Move to top.
Move up.
Move down.
Move to bottom.
To move items and subsets into other sets:
| 1. | In Sets and Items, select the item or subset you want to move. |
| 3. | Select the destination set. |
| 4. | In Resources, select the item or subset deleted from Sets and Items. |
| 5. | Click |
Recommended Comments
There are no comments to display.