Is it possible to use cross tab for normal report

[Guest]

Hi

I have a table that tracks what percent of time is spent on different projects

Eg.:
Date_Usage ProjectID Percent_usage
jan-07 1 10%
Jan-07 2 20%
Feb-07 1 30%
Feb-07 3 15%

and so on...

Its easy to get the report to look like this
Jan-07
Project ID Percent Usage
1 10%
2 20%

Feb-07
Project ID Percent Usage
1 30%
3 15%
However, I want the report to look like this

Jan-07 Feb-07 Mar-07 .........Dec-07 (upto 12 months)
ProjectID
1 10% 20%
2 20%
3 15%

I thought a cross tab query will do the job. (the cross tab query is
actually giving me the result I want) but can I use this in a normal report
(not a chart)

Thanks
Mohan

 

[Guest]

There is a solution for dynamic monthly crosstab reports at
http://www.tek-tips.com/faqs.cfm?fid=5466.