I have created a Site Collection with a number of Sites that were created using the same Site template have therefore have an instance of the same List type (Issue Tracking) - 'Tasks'. I simply want to create a Dashboard overview on the root Site of the Site Collection. The CQWP seemed an obvious choice for this. However, I can't believe that the only way to add more fields and customize it to display anything useful is to Export the Web Part, change the XML by hand and then create custom XSLT!
I literally want it to display the aggregated List content, presented in exactly the same format as the child Lists - I don't need to change the fields or provide a fancy design. Even if I did this manual process once it seems slow, error prone and time consuming. Is there anything out there that would allow me to simply define a View on child Lists and then specify that View in the Web Part properties. It would then render like any any other List.
I can develop this Web Part myself if necessary, but I want to make sure I haven't overlooked anything first.