Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2009

    Unanswered: yearly quarter report

    Hi all
    we have created table having 4 fields as
    1) cash receive daily
    2) loan receive daily
    3) advances receive daily
    4) deposit date

    we pass approx 200 entries daily on this format date 01/01/10. now we want to develop a report of first 4 months of the define year.

    For example report look like this

    Month (1)Cash Receive (2)loan Receive (3)advances Receive Total(1+2+3)
    January 10 10 10 30
    February 20 05 05 30
    March 30 10 10 50
    April 40 20 10 70

    Please Help me to how can we make a query to fetch this report from the database.


  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    select to_char(deposit_date,'MONTH'), sum(cash), sum(loan), sum(advances), sum(cash)+sum(loan)+sum(advances)
    from detail_data
    group by to_char(deposit_date,'MONTH');
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts