Michael, I suppose so, but I feel that it is just "cleaner" to denormalise (Thanks Paul!) the data first which undoubtedly makes the report easier to handle. A little like the BizObj argument really where you keep all the data processing/validation in one place and simply let the UI (report) handle the fancy output.
Whilst I agree that the multiple details lines are a good addition to VFP9 I can't say that I've had any real reason to use them as the feature doesn't add into my repertoire anything that I can't do already. In a way, I suppose old habits die hard, but I would need a very good reason to convert me from the "single cursor" approach and I've generated some very very complicated reports over the last few years. Simply on the basis of output of the raw data to a dbf file that can be read by Excel, which is a feature of all my reports would negate the use of Multi Detail lines. However, I'd be interested to find out just how many "old foxers" have used the Multi Detail feature to do something "easier" than my preferred method. Go on guys, someone convince me different. Dave Crozier -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MB Software Solutions Sent: 17 May 2007 16:37 To: [email protected] Subject: Re: Report in VFP9 Dave Crozier wrote: > 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. > > While I can appreciate your comment (as I see it the same way), doesn't that approach defeat the usage of using multiple detail bands in the new VFP9 report writer? -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com "Work smarter, not harder, with MBSS custom software solutions!" [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.
