Sorting a String within a Subquery

Am I understanding correctly that I need to have two reports (.rdl) files, as well as a unique dataset for each?

Correct.
The main report
this would be what you have today

the subreport
this would be the query that you are putting into the column field today.

It is hard to tell what you are doing. If you have screenshot of the final product it would help with this discussion. Sounds like you are just starting out, which add to the fun. :slight_smile: