How to display in table format in Crystal Reports 8.5

Actually  I have  a table Consumption which contains the fileds date,Volume.
Data for these fields are

 01/01/2000, 1000
 02/01/2000, 2000
03/01/2000, 3000
04/01/2000, 3000
05/01/2000, 3000
06/01/2000, 3000
01/01/2001 , 2000
02/01/2001,  4000


I can call the database and display the line items one by one. But i want is to display these in different fomat.The format is below.
                             (year)
Month                  2000        2001            2002   2003


jan                      1000         2000
feb                      2000         3000
march                  3000
april                     3000
may                     3000
june                    4000
july
august
september
october
november
december


Do any body explain me how to do this one.
pavan738Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Brian CroweDatabase AdministratorCommented:
You'll want to group by month.  Create a formula to calculate the month of the date value and group on that.

If the years are static then you can create separate formulas for each year

Formula: 2000

If Year({datefield]) = 2000 Then
   {datefield}
Else
   0

repeat for each year you want a column for

create summaries for each of these "year" formulas grouped by month and display those.
wykabryanCommented:
Or a simple cross tab query would give you this same results.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.