Eurico, I suggest normalising the files for input into your report so that you end up with one cursor to print from as opposed to using the report DE to set up all the relationships.
In the case of differing detail types then add a "record_Type" field to distinguish the detail level. This makes the whole design of the report much, much easier regardless of the version of VFP you use. I'd prefer to slave over an SQL statement than setting up a complicated report - especially if the report is ever to be changed. Dave Crozier -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Eurico Chagas Filho Sent: 17 May 2007 15:43 To: 'ProFox Email List' Subject: Report in VFP9 Hi I need some help to get a report working using the new features of VFP9( several detail bands) I got TableX(CodeX), TableA(CodeX, CodeA), TableB(CodeA), TableC(CodeA) and TableD(CodeX). In VFP7 I would construct a select and use Print When. TIA, E. No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.467 / Virus Database: 269.7.0/804 - Release Date: 5/14/2007 4:46 PM [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://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.
