title: Creating parent child label columns in SSRS
body: <p>I have a stored procedure and an ssrs report that takes work orders of a certain category (user entered parameter, ex. A,B) and then selects other work orders of the unselected categories (C,D) that are within a user entered buffer distance (parameter). The listing that the report generates contains a Primary Work Order Id field (Primary WOID) and a Buffer Work Order Id field (Buffer WOID).  I need to create a single column that indicates the parent/child (Primary/Buffer) relationship as well as well as the grouping of the records. The screenshot below is an example of what I would want the new column to look like. 
  <a href="https://i.stack.imgur.com/yoqjC.png" rel="nofollow noreferrer">desired column in listing report</a>. I'm using Report Builder 3.0 and SSMS v17.2 . </p>