Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Deane Robieson
  Where is Deane Robieson?
 New Zealand
 Deane Robieson
 To: tushar Kanvinde
  Where is tushar Kanvinde?
 Kolhapur, Maharastra
 tushar Kanvinde
Subject: RE: 'Normal' bands between Detail bands
Thread ID: 310738 Message ID: 310855 # Views: 33 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Reports and Printers
Date: Sunday, June 26, 2011 4:17:43 AM         

> > Hi All.
> >
> > I believe I need a report with two detail bands, but would like to have a 'normal' band between them.
> >
> > Details are these: A client may have several products on hire from the company. I want a report with the Clients name and address in the Header band. At the bottom of the header band, I can put the heading 'Products'.
> >
> > This would be followed by a detail band listing the contents of the Products table.
> >
> > Next, I would like another 'normal' band with the title 'Transactions' (this is the band I am unable to insert).
> >
> > Then comes a second details band listing the contents of the Transactions table.
> >
> >
> > I have been able to insert multiple Details bands in the report designer, but am unable to insert a 'normal' band between the two Detail bands.
> >
> > Can someone please point me in the right direction ?
> >
> > Thanks
> >
> > Deane
> I think you want a header band for the transaction band. Right click on the detail2 and choose properties. In the Band page, choose "Associated header and footer bands"
> Regards
> Tushar

Thanks Tushar.

I think you have me on the right track, but I'm not quite there yet.

The requirements have changed slightly - there is now only 1 product to be shown on the report, and many transactions.

I have put the product details on the report header, followed by the transactions in a Detail band with an associated detail header band, like this...

My problem now is that the detail header is being repeated for each transaction, like this...

Is there a setting to make the transaction header print only once ?



'Normal' bands between Detail bands Posted by Deane Robieson @ 6/24/2011 2:32:02 AM
RE: 'Normal' bands between Detail bands Posted by tushar @ 6/24/2011 6:21:55 AM
RE: 'Normal' bands between Detail bands Posted by Deane Robieson @ 6/26/2011 4:17:43 AM
RE: 'Normal' bands between Detail bands Posted by tushar @ 6/26/2011 8:23:08 AM