I have a different kinds of information to be shown on report ,which are in seperate  tables and tables are linked together and can be joined, but joining them in one query is making it too complex and difficult to understand.
Which approach is suitable i.e a Subreport for every information or use different command objects for every information.

Or simply when do we prefer to use subreport or use different command objects for a very complex query.