If I was creating the report I would do exactly what you are doing, I would create separate datasets for each distinct query. As you say, if you try to combine these into a single query it will be complex, and it will then make the charts more complex.

So, carry on the way you're going, you seem to be doing ok.

Regards,