How to display in table format in Crystal Reports 8.5

Posted on 2006-04-03
Last Modified: 2012-06-21
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.
Month                  2000        2001            2002   2003

jan                      1000         2000
feb                      2000         3000
march                  3000
april                     3000
may                     3000
june                    4000

Do any body explain me how to do this one.
Question by:pavan738
    LVL 34

    Expert Comment

    by:Brian Crowe
    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

    repeat for each year you want a column for

    create summaries for each of these "year" formulas grouped by month and display those.
    LVL 16

    Accepted Solution

    Or a simple cross tab query would give you this same results.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
    Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now