Duncan You would have to create a view and then base the report on the view. Place a column for skills, language and volunteer work in the detail section. Also set a break on employee number.
Buddy -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Walker Duncan Sent: Monday, April 01, 2013 10:55 AM To: RBASE-L Mailing List 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
