Mike it's been a while since I've done one with multiple detail bands but yes I believe you need to use both SET RELATION and SET SKIP.
Warm regards Darren <div>-------- Original message --------</div><div>From: [email protected] </div><div>Date:08/07/2015 15:33 (GMT+10:00) </div><div>To: [email protected] </div><div>Cc: </div><div>Subject: Re: SET RELATION TO and multiple detail report bands in VFP9SP2 RW </div><div> </div>Hi Darren, Thanks for the reply. Do you have to use SET SKIP also? tia, --Mike On 2015-07-07 19:22, Darren wrote: > Set relation and set skip. > > <div>-------- Original message --------</div><div>From: > [email protected] </div><div>Date:08/07/2015 > 09:13 (GMT+10:00) </div><div>To: [email protected] </div><div>Cc: > </div><div>Subject: SET RELATION TO and multiple detail report bands > in VFP9SP2 RW </div><div> > </div>I have a need to use the "new" (lol) multiple detail band feature > in the > "new" VFP9 Report Writer. Honestly, I had a bad experience with SET > RELATION back in the VFP6 days, and once I changed from direct table > mappings in the app to Local Views, I happily dumped SET RELATION. > > This app has a hierarchy like this: > Job > --Items > --Fees > > I want to create a report that uses one detail band for the Items, and > one detail band for the Fees. > > Has anyone done this successfully and have any tips? Wanted to tap > someone's positive experiences with it. (Typically, I always created a > single flat file for reporting.) > > tia, > --Mike > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious. Report [OT] Abuse: http://leafe.com/reportAbuse/[email protected] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

