Victor - Brian described it as well as it can be described. I like using two level reports and this function together but that's as much out of habit than anything else.
The simple idea is to create file names that contain all or part of your own description of the category so that when you're done you know what you have. Let us know how you make out or where you're stuck. Don On Mon, Oct 6, 2008 at 6:41 PM, Victor Warner <[EMAIL PROTECTED]> wrote: > Don and Brian, > > Thank you both for the responses. > > Beyond a certain point (and what you describe is way beyond that point!) I > do not have the knowledge to implement what is suggested. > > Would it be possible to have a few pointers on the mechanics of > implementing one of the suggestions? > > Victor Warner. > > > Brian Hancock wrote: > >> Hi Victor, >> >> Don's suggestion sounds fine. Personally I have never been a fan of the >> two-level report, no specific reason just haven't found reason to use it >> much. >> I would base my report on the lookup panel, and in the report body of this >> panel store the required filename into an RV, depending on whether you >> want >> empty files for empty categories, or files only records exist for that >> category you would place an Open Filename in RV in the report body, of the >> Category Panel or in the FirstPage header of a Linked or Virtually Linked >> Panel to your second panel where the data is, and then output the data. >> >> You might need to turn file on and file off, to make sure you do not get >> appends, or prompts to overwrite. >> >> As yet an even third choice might be to let records append by basing the >> report solely on the second panel, without even using a Two-Level report. >> Just open the filename in RV changing it for the character heading for >> each >> report. Unless you use a Turn File Off the data is appended to the >> existing >> file. A big disadvantage of this however is that you will be asked whether >> you want to overwrite the existing record which you would have to answer >> yes >> to at each record which reopened an existing file, however for a a report >> with just a couple of hundred records is a nice quick and dirty method, >> which allows you to view records one by one as they are written >> >> Regards >> Brian >> >> >> -----Original Message----- >> From: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED] On Behalf Of Victor Warner >> Sent: Monday, 6 October 2008 10:58 PM >> To: [email protected] >> Subject: [Dataperf] Reports query - sending each record to a different >> filename. >> >> I would like whether the following is possible in DataPerfect: >> >> 1. There is a (first) panel where one field in each record acts as a >> category (which is obtained by a data link from a second panel). >> 2. In the first panel there be several records each having the same >> category heading. >> 3. I would to produce a report where all the records sharing the same >> category heading are sent to a file, then the report proceeds to the next >> category heading and sends all the records under that second category >> heading to a second file. (I can do this where the records are sorted and >> sent to the same file name.) >> >> Is this possible to run one report and that the files are automatically >> created or do I need to do separate reports? >> >> Help with this would be gratefully received. >> >> Regards >> >> Victor Warner. >> >> _______________________________________________ >> Dataperf mailing list >> [email protected] >> http://lists.dataperfect.nl/mailman/listinfo/dataperf >> >> _______________________________________________ >> Dataperf mailing list >> [email protected] >> http://lists.dataperfect.nl/mailman/listinfo/dataperf >> >> >> > _______________________________________________ > Dataperf mailing list > [email protected] > http://lists.dataperfect.nl/mailman/listinfo/dataperf > -- Don Friedman ProfessionalRecords.Com LLC PRS Data Systems 205 S Main Street Pittsburgh, PA 15215 412-784-1600 - 1-800-PRS-FILE 412-784-1615 Fax
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
