Can you provide how the report output would look like. I am thinking maybe you can create a Crosstab which would dynamically update the report matrix based on the resultsets.