You can use CTEs in the RDL query of your report. If all of the data is in the SSRS tables, you could build a recursive CTE and create it that way. There is one caveat, and I would have to look this back up, but there is a symbol you need to put at the beginning of a CTE statement for the RDL to accept it.