OrgChart Now Help Guide

Table of Contents

Auxiliary Reporting


Audience: Administrator Users Edition: Enterprise & Premium


When an employee has more than one manager, Administrators can configure auxiliary reporting in OrgChart, even if the main HRIS data does not support dual-reporting. The following article provides step-by-step instructions for displaying auxiliary relationships in OrgChart.

Configuring Auxiliary Reporting

The following section provides step-by-step instruction for configuring auxiliary reporting in OrgChart when it already exists in your HRIS.

  1. Log into OrgChart Viewer.

  2. Click on More > Chart Settings.

  3. Click on the Settings dropdown menu, and then select the Mapping option.

  4. Click on the + New Mapping button (at the bottom of the mapped fields list), and then select the Aux Supervisor ID option.

  5. Click on the Aux Supervisor ID dropdown menu, and then select the field name associated with this field mapping (i.e. Aux Supervisor ID).

  6. Click on Save, and then Refresh. OrgChart Now duplicates the employee record of the auxiliary report, so that their record appears under each of their supervisors.


    Note: Auxiliary reports will not affect the total headcount of your organization.

  7. Optionally, read the Formatting Auxiliary Reports section below for instructions on targeting auxiliary employees with conditional formatting.

Merging Auxiliary Reporting

If your HRIS does not support Auxiliary Reporting, you can use a Merge File (Excel or CSV) to represent dual-reporting in OrgChart.

  1. Log into OrgChart Viewer.

  2. Click on the Export icon, and then select Excel.

  3. Select This Page from the list of options. The Excel file begins to download.

  4. Open the Excel file after the download is completed.

  5. Delete all rows with employee data.

  6. Delete all columns with the exception of the field mapped to PersonID. If you are unsure which field in your data maps to PersonID, verify your mapping configuration in the Chart Settings: Mapping panel.

  7. Add a column header called Aux Supervisor ID.

  8. Optionally, add a column called Info for your reference.

  9. Enter the PersonID for the employee who has more than one manager in the PersonID column.


    Note: You can find an employees PersonID by clicking on an employee record, and then clicking on the Profile icon. If the Profile icon does not contain PersonID, add the PersonID field to the Profile in the Chart Settings: Profile panel.

  10. Enter the PersonID for the secondary manager in the Aux Supervisor ID column.

  11. Optionally, add a note about the entry (for your future reference) in the Info column.

  12. Click on File, and then click on Save As.

  13. Save this document using the following naming convention: CompanyName_AuxMerge.

  14. In OrgChart Now, click on More > Chart Settings.

  15. Click on the Plus_light.png icon (under the Merge Data heading). The List of Merge Data Connectors is displayed.

  16. Click on the Excel icon, and then click on Select. The Excel icon is displayed under the Merge Data heading.

  17. Click on the Browse button (associated with the Excel icon). The File Manager is displayed.

  18. Select the Data folder (from the right hand column), and then click on the ViewSettings_Save_Icon.png icon (in the upper-right corner).

  19. Search for and select the Aux Merge file (saved in step 13), and then click on Open. The file is imported into OrgChart.

  20. Click to highlight the Aux Merge file, and then click on Select.

  21. Click on Save, and then Refresh.

  22. Follow the steps outlined in the Configuring Auxiliary Reporting section above to finish merging Auxiliary Reports into OrgChart.

Formatting Auxiliary Reports

Design a Box Style specifically for auxiliary reports, and then use conditional formatting to identify these employees. The following section provides some ideas for formatting auxiliary boxes. Reference the Box Layout Editor and Rule-Drive Charting articles for more information.

  1. Log into OrgChart Viewer.

  2. Click on More > View Settings.

  3. Click on the Shared Styles tab (at the top of the right side panel).

  4. Click on the addtemplate.png icon to add a new Shared Box Style, and then rename it "Aux."

  5. Right-click the newly added Box Style, and then select the edittemplate.png icon. The Box Layout Editor is displayed.

  6. Click on the bottom cell of the box.

  7. Click on the BLE_AddNewRowBelow.png icon (in the top tool bar) to add a new row below the selected cell.

  8. Right-click within the newly added cell, and then type "Also Reports To."

  9. Click on this field to add it to the box.


    Note: Once applied to the chart, users can click on the Also Reports To field, and jump to the listed supervisor's subchart.

  10. Optionally, with the Also Reports To cell highlighted, click on the BLE_LabelOptions.png icon (in the top tool bar), and then select the Lable:Value option. Then click on the BLE_JustifyText.png icon (in the top tool bar) to align the text to both the left and right margins.

  11. Click on the Save button. The Box Style is added to the Shared Box Styles Library.

  12. Click on the BLUE_SaveIcon.png icon (at the top of the right side panel).

  13. Select the View to which you would like to add the Also Reports To feature.

  14. Click on the addtemplate.png icon to add a new rule.

  15. Configure a rule that targets the auxiliary report (see examples below), and then click on OK.

    • isAux - Use the system generated isAux field to apply a certain box style to records whose isAux field value is greater than 0. See the example rule below:

      Example Rule:

    • Also Reports To - Use the system generated Also Reports To field to to apply a certain box style to records whose Also Reports To field is not empty. See the example rule below:

      Example Rule:

  16. Optionally, click on the Box Properties tab to further edit the presentation of the Aux box. The following example uses a dashed connecting line, as well as a dashed border.

  17. Click on the SaveIcon.png to save the View.