Jim, It sounds like your database -- or at least, this report -- has some design deficiencies in the "one to many" relationship department.
Try this: in the report create a variable named rvDefendants Use this expression for it: (LISTOF(defendant)) IN sametablename WHERE fileno = fileno (whereever I have something in lower case, you have to substitute the appropriate column name or table name from your own database.) Then locate the rvDefendants variable instead of the column, and use the LIMIT=1 criteria to print the report only once for the file number. Bill On Tue, 4 Feb 2003 15:47:59 -0600 (Central Standard Time), Jim Van Dillen wrote: >FLAVOR00-NONE-0000-0000-000000000000 ; 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 hav
