creating a report from a cross tab query

I have a crosstab query that uses the between (two dates) function.
The query works fine but when I try to create a report out of it it
says that the row source is incorrect and will not create the
(tabular) report. Is there any way of fixing this?