Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Srinivas Sarma
  Where is Srinivas Sarma?
 jamshedpur
 India
 Srinivas Sarma
 To: Barbara Peisch
  Where is Barbara Peisch?
 Oceanside
 California - United States
 Barbara Peisch
 Tags
Subject: RE: Detail Report
Thread ID: 143275 Message ID: 143345 # Views: 2 # Ratings: 0
Version: Visual FoxPro 9 Category: Reports and Printers
Date: Tuesday, August 28, 2007 6:16:23 AM         
   


Thanks Barbara

Regards
Srinivas



> You don't need multi-detail bands to do this. You just need data grouping.
>
> Build a cursor that has the main ledger, subledger and transaction information in each record. Then add a group to your report on Mainledger, a second one on Subledger, and put the transaction info in the detail band. You can put all the info about the main ledger and subledger in the group header and footer for each of those data groupings.
>
> > Hi,
> >
> > I need to make a ledger report.
> >
> > T_ac,T_cl,Tran1 are tables.
> >
> > T_ac(structure)
> > Accode(Main Ledger)
> > Acname
> >
> > T_cl(structure)
> > Class (sub-ledger)
> >
> > Tran1(structure)
> >
> > Type
> > Accode
> > p_amt
> > R_amt
> > Class
> >
> > Report should be Main-Ledger and Subledger.
> >
> > Main Ledger
> >
> > Subledger
> >
> > Transactions.....
> > Subledger Closing
> >
> > .......
> > Main Ledger
> > ......
> >
> > Can it be made using VFP9 multi band. Pl. guide me.
> >
> > Regards
> > Srinivas
> >
> >
> >
> >
> >
> >
> >
> > srinivas
>
>
>
> -BP
> www.peisch.com



srinivas

ENTIRE THREAD

Detail Report Posted by SRINIVAS SARMA @ 8/27/2007 12:32:52 PM
RE: Detail Report Posted by Barbara Peisch @ 8/28/2007 4:05:37 AM
RE: Detail Report Posted by SRINIVAS SARMA @ 8/28/2007 6:16:23 AM