You may not like this answer but the easiest way is to upgrade to 9.5 v32 and take advantage of sub-reports.
-----Original Message----- From: Walker Duncan <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Mon, 1 Apr 2013 10:54:59 -0400 Subject: [RBASE-L] - report question in Version 6.5 for windows > I need some help . I have a master table showing demographic info > (i.e. name address etc). I have another table showing skills of each > member and another table showing other languages spoken and a final > table showing the total hours volunteered for each year. > > I wanted to bring information on skills, languages, hours and some > demographic info into one report. The volunteer employee number is in > all tables. I created a view including all the tables. The report was > designed in Report Designer. I have the demographic info in a Header > Section and Skill, Languages, and Hours in columns in the Data Section. > The problem I have is one record may list 5 skills, 2 languages and 3 > years of hours. When the report prints, the 5 skills are listed and the > languages listed are not 3 but 5 as some are repeated and 5 years of > hours are also listed with repetition to make up 5 entries. > > How do I get Skills, Languages and Hours to list unique values i.e. > Skills should list the 5 Skills, Languages should list the 2 languages > and Hours should list the 3 years of hours. > > Appreciate any help. > > Duncan >
