so i think i figured out how to solve my issue by using the crosstab query and then generating the report based on this query but the problem i am facing now is that i need to run this report every 3 months meaning that in march i will see january february march as the column headers
then 3...