Jim - I posted a message earlier but I don't think it ever made it to the list - so I'll try again.
What you can do is revise your report and add a break header based on the field "fileno". Move all the fields from the detail section to the break header that remain the same for each file - when it prints, the information for each fileno will print just once. Leave the fields for the Defendant, etc in the Detail section. And for the record - it sounds like Bill Downall is correct - your data structure may not be normalized - but if this report works for you , then you might not want to worry about it ... Sami ----------------------------------------------------------- Sami Aaron Software Management Specialists 19312 W 63rd Terr Shawnee KS 66218 913-915-1971 [EMAIL PROTECTED] http://www.softwaremgmt.com ----- Original Message ----- From: Jim Van Dillen To: RBASE-L Mailing List Sent: Tuesday, February 04, 2003 3:47 PM Subject: [RBASE-L] - Re: Extracting column values These are records for maintaining a court docket. We make a additional record under the same "fileno" for each defendant in a particular suit. The court division number, county where filed, court case #, party suing and court date are the same for all defendants in a particular case. We are trying to produce one report "court memo" for each case which contains the contains the above information for a particular "fileno" even though there may be several records with that same "fileno"; they are the same law suit at court. We need to produce a report "court memo" which prints the names of all the separate defendants on the report, calling up the fileno by the non-unique "fileno". The partial solution for the moment was the earlier suggestion of adding "AND LIMIT = 1" to the print statement which now just print the report once using the name of the defendant in the first record found in the search. Thanks in advance for any suggestion you might have. JIM VAN DILLEN Attorney at Law 1505 S. Big Bend Blvd. St. Louis, MO. 63117 (314) 645-8008; Fax (314) 645-8016 [EMAIL PROTECTED] -------Original Message------- From: [EMAIL PROTECTED] Date: Tuesday, February 04, 2003 14:01:39 To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Extracting column values I'm probably not getting it. My understanding is that up to 3 records may have the same fileno, and you want the name info from one record. It's not the fileno that I was wondering about, but the name info.... do all the records have the same name information? Ben Petersen On 4 Feb 2003, at 13:45, Jim Van Dillen wrote: > > I know I have the right records since the "fileno" prints out on the > report itself. > > -------Original Message------- > > From: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > Date: Tuesday, February 04, 2003 08:47:40 > To: RBASE-L Mailing List <mailto:[EMAIL PROTECTED]> > Subject: [RBASE-L] - Re: Extracting column values > > Jim, > > You can append "and limit = 1" to the end of the where clause of your > select/print statement. > > But, out of curiosity, how do you know you got the right one? > > Ben Petersen > > > On 4 Feb 2003, at 1:16, Jim Van Dillen wrote: > > > > > I am trying to create a report which extracts column values from > > non-unique records. > > > > I need to extract name values for listing names in a report > > searching for records by a fileno field which is non-unique (usually > > never more than 3 records which could have the same fileno). > > > > Using a print statement as follows: > > > > Print <report> fileno = <colvalue>. The problem is that now if there > > are two records under the same fileno, the report prints twice, once > > for each name in a record under the same fileno instead one report > > listing each name found. > > > > We have tried statements like: > > > > "Select into <var>, <tablename.colname> where fileno = <varfileno>" > > but have still been having two (or more) reports print. > > > > Any help would be appreciated. You may reply privately if you wish. > > > > Thanks, > > > > JAMES L. VAN DILLEN > > Attorney at Law > > 1505 S. Big Bend Blvd. > > St. Louis, MO. 63117 > > (314) 645-8008; Fax (314) 645-8016 > > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> < > mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > > > > > > > > > > > . > > > .
