If you base the query on the resolution object itself you will be able to get all the details of the related Incident in the results, this will of course mean that you'll get duplicate results if you have more than one resolution on an Incident. The results will not include any Incidents that don't have any resolutions on.
If you want a single query to pull out resolution data on all Incidents (regardless or whether they have been resolved or not) then I'd recommend using a Crystal Report.
Then is it true, that any results from a query which stem from a 'collection' simply, can not be exported into Excel?
If you want to export data from the collection, you need to create the query on the collection item, and from there add attributes from the related incident/request/change/task.
Elizabeth is right here. Even i faced the similar issue. Later i have created a separate query on the Resolution for all the incidents and requests.But this query will pulls and show you only the Resolved calls. If you want to see or else want to export only resolved calls, then creating a query based on Resolution will helps.