Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Jun Tangunan
  Where is Jun Tangunan?
 Cabanatuan
 Philippines
 Jun Tangunan
 To: prasanna kunder
  Where is prasanna kunder?
 mumbai
 India
 prasanna kunder
 Tags
Subject: RE: how to use Detail Band in Report
Thread ID: 373292 Message ID: 373297 # Views: 59 # Ratings: 2
Version: Visual FoxPro 9 Category: Reports and Printers
Date: Thursday, March 21, 2013 1:03:51 AM         
   


> Hello Expert
>
> pl.guid me how to use Detail Band
>
> i have a data like this
>
>
>
Bill.No. Amount Int_Type
> 1          400   int
> 1          200   int
> 1          300   int
> 2          100   int
> 2          500   int
> 2          600   gnl       
> 2          700   rbt
> 3          150   int
> 3          350   int
> 3          450   rbt

>
> now i want report like this
>
>
Bill.No. Amount Int_Type
> 1          400   int
> 1          200   int
> 1          300   int
>           -----
>   total   1000
>           =====
> 2          100   int
> 2          500   int
>           -----
> subtotal   600
>           -----
> 2          600   gnl       
> 2          700   rbt
>           -----
>   total   1300
>           =====
>  
> 3          150   int
> 3          350   int
>           -----
> subtotal   500
>           -----
> 3          450   rbt
>           -----
>   total    950
>           =====
> 

> pl.guide me how to do
>
> thanks


In addition to what Tamar says, you need to employ conditional sub-totalling because if you don't, then your GNL will have a sub-total as well as RBT for BillNo 2 field. The trick is really simple: http://weblogs.foxite.com/sandstorm36/2008/10/10/conditional-sub-total-printing/


http://sandstorm36.blogspot.com
http://weblogs.foxite.com/sandstorm36

ENTIRE THREAD

how to use Detail Band in Report Posted by prasanna kunder @ 3/20/2013 7:49:52 PM
RE: how to use Detail Band in Report Posted by Tamar Granor @ 3/20/2013 9:26:50 PM
RE: how to use Detail Band in Report Posted by Jun Tangunan @ 3/21/2013 1:03:51 AM