Example: Use the same entity to display different data in multiple columns

1. From the Report Data Object Management page, click Add and then select Employee View or Business Structure Represents the logical structure of an organization as it concerns staffing. It contains the locations and jobs to which an employee may be assigned. View. The New Report Data Objects page opens. This is where you define the collection of columns that will be used in your report.
2. On the New Report Data Objects page, enter the Report data object key and enter the description of the data object in the Description field.

3. Select or clear the Column Relationship Rules check box. By enabling this check box, you can only create RDOs with entities that have defined relationships in the system. If needed, you can clear the check box so you can create RDOs that may render data in different rows for the selected grain in the RDO.

4. Note: The Column Relationship Rules option is only available when enabled and allowed. See Ability to Disable Column Relationship Rules.

4. To use the same entity with different assignments:
   1. In the Columns area, click Add .
   2. In the Select Column glance (also known as a contextual callout) Provides information and actions in a dialog box for an item on the screen when the user right-clicks or taps the item., select an entity. In the phone number example, select the Employee Details entity with the Phone Number column.
   3. In the Add Column Properties glance, edit the label and assignment, then click Add Column. For example, change the label to Home Phone and the assignment to Phone 1.
   4. 
   4. Repeat steps b and c, selecting the same entity and changing the label and assignment for each column. For example, change the label to Cell Phone and the assignment to Phone 2 and then repeat the process, changing the label to Work Phone and assignment to Phone 3.
   5. 
   5. When finished, click Save. The report in the example will have and an Employee Full Name column and three columns for phone numbers: Home Phone, Cell Phone, and Work Phone.

1. From Common Setup, select Unpublished Reports or Published Reports.
2. Select Create . from Unpublished Reports or Create Design from Published Reports. Report Studio opens in a new tab with the report template displayed.
3. If no report data objects are listed:
   1. Click the layout pane (the block labeled Select and drag item to insert the available data).
   2. In the Select Data glance, select the applicable report data objects from the Available Data box and move them to the Selected Data box. When finished, click OK. The selected data object are now listed in the Data column on the left side of the screen.
   3. To review the possible columns, expand the applicable report data object and then expand the corresponding BaseDataSet.
4. Select Insert > Table > Table to open Table Builder. Table Builder contains two tabs: Data and Filter.
5. From the Data tab:
   1. Expand the Use Data From drop-down list and select the desired report data object. You can only select one report data object.
   2. Expand the report data object to display the possible columns.
   3. Hold down the Ctrl key and select the columns to include in the table and then click the right arrow to move them to the Current Column Selections box. You can change the order of the columns by using the up and down arrows.
6. 
6. If necessary, click Add Filter, select the data object in the Filter By drop-down list, add a condition and value, and click OK.
7. Click OK in Table Builder.

1. When finished defining the columns, select Save and View.
2. Give the report a name in the File Name field and click OK.
3. In the Parameters glance, select the applicable information:
4. Time Frame

   • Start Date — Enter the time frame start date.
   • End Date — Enter the time frame end date.
5. Hyperfind Selector

   • Hyperfind A search engine that filters and selects groups of employees through queries that specify conditions or locations (criteria). — Enter one of the Hyperfinds
   • People Ids — Leave this blank.
   • Location Ids — Leave this blank.
   • Organization Ids — Leave this blank.
   • Show Chart — Select Yes or No to show a chart.
   Parameter type

   • The parameter type is listed at the bottom of the Parameters glance. Note that only one is listed even if you defined more than one. By default, the system combines the same entities with multiple assignments.
   • To display each column separately, select No Value as the parameter value. When you select No Value, individual values will display in the report columns. If you do not select No Value and have a single value selected, all the columns are rendered based on that value. Click OK when finished.
   • 

   A preview of the table report opens. You can return to the report design and modify it as needed,

4. When finished designing the report, select File > Save as and give the file a name and description in the Save As glance, then click OK. The report is now listed in Unpublished Reports

When you publish the report, you can hide this parameter and make it non-mandatory.

1. From the Unpublished Report page, select the report and click Publish . The New Published Report page opens.
2. Enter the report name, description, label, default output type, and category.
3. In the Report Parameters area, select the parameter that you edited in step 3, for example, Home Phone and, in the Edit Report Parameter glance, change Mandatory and Display to False and click Apply.
4.