Yes,
You base your report source on a table or a query, so you can create a cross
tab query or any other query and then display the result of that query in a
report.
A query should return the desire data, and the report will display it in a
nice way.