I'm with Dennis. You need a temporary table. Leave the hours NULL when
they do not match. This is about the only way to leave hours blank when
they don't match up.
Albert
On 01/04/2013 10:24 AM, Walker Duncan wrote:
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
-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2013.0.3267 / Virus Database: 3161/6218 - Release Date: 04/01/13
