Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Patrick Danso
  Where is Patrick Danso?
 Accra
 Ghana
 Patrick Danso
 Tags
Subject: How to Group Data on Report
Thread ID: 344990 Message ID: 344990 # Views: 33 # Ratings: 0
Version: Visual FoxPro 9 Category: Reports and Printers
Date: Wednesday, May 16, 2012 9:29:33 PM         
   


Hi Friends,
I have created a view called V_Loansdisbursment, and this is how it looks like;
Transid dis_date Name chq_bank amount
001 01/01/2012 John PLC Bank 150
005 15/01/2012 Fred SSB Bank 285
009 01/02/2012 Gina SSB Bank 680
003 20/01/2012 Pat PLC Bank 1000
010 01/01/2012 Hook SSB Bank 360
016 15/01/2012 Rita SSB Bank 750
002 01/01/2012 Yaa PLC Bank 1500

The report is the same as the view is, I want to group them by dis_date and SUM on the dis_date on the report. I want my report to look like the below;

Transid dis_date Name chq_bank amount
001 01/01/2012 John PLC Bank 150
002 01/01/2012 Yaa PLC Bank 1500
010 01/01/2012 Hook SSB Bank 360
Total for 01/01/2012 2,010

005 15/01/2012 Fred SSB Bank 285
016 15/01/2012 Rita SSB Bank 750
Total for 15/01/2012 1,035

009 01/02/2012 Gina SSB Bank 680
Total for 01/02/2012 680
003 20/01/2012 Pat PLC Bank 1000
Total for 20/01/2012 1,000

Thank you

ENTIRE THREAD

How to Group Data on Report Posted by Patrick Danso @ 5/16/2012 9:29:33 PM
RE: How to Group Data on Report Posted by Tamar Granor @ 5/16/2012 10:29:40 PM
RE: How to Group Data on Report Posted by Patrick Danso @ 5/16/2012 10:49:36 PM