Displaying counts based on dates

[olmos]

I need to create a report with a total count for items in a different categories.
Then I need to get the total number of items in each category for each month Jan, Feb, ....Dec., by each fiscal year quarter, and then by fiscal year.

I am doing this so far by querying the same table again and again based on
the above, but this seems like too many queries to create and then output.
Is there another way of doing this?

Thanks,
olmos.

 

[webmigit]

Lemme see your query and output code, I'll help if I can.

 

[olmos]

This is what the output results should look like
How do I count the totals for each month and category. Someone suggested using
Structures but I am not sure.

Months Category 1 Category 2 ...

Oct 2000 77 33
Nov 2000 44 36
Dec 2000 23 56

Jan 2001 32 45
Feb 2001 34 67
Mar 2001 45 78

and so on ...

..
total for each Quarter 1
The months are out of order because it is based on a fiscal year which starts on Oct

Thanks,
olmos

 

[webmigit]

In order to help, I've gotta see your query and output code (cfoutputs)... otherwise can't help, sorry.