Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Tamar Granor
  Where is Tamar Granor?
 Elkins Park
 Pennsylvania - United States
 Tamar Granor
 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: 373294 # Views: 65 # Ratings: 2
Version: Visual FoxPro 9 Category: Reports and Printers
Date: Wednesday, March 20, 2013 9:26:50 PM         
   


> 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

Add two groups in your report. For the first group, specify BillNo as the group expression. For the second group, specify Int_Type as the group expression. Use the group footers for your subtotals and totals.

Tamar

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