Populating a Single Cell with List Values

In Bullhorn Reporting (previously Canvas), you can obtain a list of skills that are comma-separated on the same line.

Steps

For our example, we will get a list of skills per candidate on the same line.

  1. Start by creating a list report
  2. Under Insertable Objects, click the Sources tab. Select Candidate Analysis > Candidate > double-click Candidate ID > double-click Name > double-click Status.
  3. Under Insertable Objects, click on the Toolbox tab, then drag and drop Crosstab to the last column on the table.
    • Crosstab must show as a column title in order to do later steps.
  4. Under Insertable Objects, click the Sources tab, then select Candidate Analysis, then select Candidate. Drag and drop Candidate ID to Rows in the crosstab.
  5. Under the same Candidate, drag and drop Skills to the Columns in the crosstab.

  6. In the crosstab column, click Candidate ID, then select More > Master Detail Relationships….
  7. In the Master detail relationships pop-up, click on NEW LINK > Candidate ID > Candidate ID OK.
  8. In the Show Properties pane, under BOX, click Box Type. in the drop down, select None.
  9. Click on the dots in the empty space to the left of the first Skills column.
  10. In the Show Properties pane, under BOX, click Box Type. in the drop down, select None.
  11. Click on the Skills row.
  12. On the toolbar, click on Borders and select Default Borders, then click OK.
  13. In the Show properties pane, scroll to Box, then click Padding > More.
  14. In the Padding pop-up, set all values to 0 and click OK.
  15. Under the same Box section, then click Border> More.
  16. In the Border pop-up, make sure the Style is set to Solid line, the Color is White, and the first box under Preview for Apply All Borders is selected, then click OK.
  17. Click Lock Page Objects to unlock the report.
  18. Go back to the Toolbox on the left pane and select Text Item and drag and drop it just after Skills on the horizontal axis.
    • Make sure the cursor is blinking behind Skills before you drop.

  19. In the Text pop-up box, type a comma (,) and click OK.
  20. Click Run Options to view your report.

Records without content on the horizontal value (Skills in our example) will show a single comma. The list will end with a comma.