M
Mohan
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
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