On 2013-04-01, at 11:55 AM, Duncan <[email protected]> wrote:
>
> On 2013-04-01, at 11:45 AM, Duncan <[email protected]> wrote:
>
>> That is what I did. The report was designed in the view. I have one header
>> which is the employee number. The Skills , Languages and Hours are in the
>> detail section. What happens is is as follows as per my example.
>>
>> This is what I expect on the printout
>>
>> Skills Languages
>> Hours
>>
>> Computer tech French
>> 234
>> security officer Italian
>> 300
>> mechanic
>> 276
>> electrician
>> bartender
>>
>> This is what I get
>>
>> Skills Languages
>> Hours
>>
>> Computer tech French
>> 234
>> security officer Italian
>> 300
>> mechanic French
>> 276
>> electrician Italian
>> 234
>> bartender French
>> 300
>>
>> Note the Languages and Hours repeat until there are 5 entries which equals
>> the number of entries in Skills
>>
>>
>>
>>
>> On 2013-04-01, at 11:25 AM, Buddy <[email protected]> wrote:
>>
>>> 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
>>>
>>>
>>
>
