Correction: 1. Get employee 2. make cursors for each or the 3 subsets 3. fetch from each of the cursors 4. if any of the 3 subsets retrieved data, push a record into report table, and repeat #3 5.if no subset data left, go back to #1
Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dennis McGrath Sent: Monday, April 01, 2013 10:48 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: report question in Version 6.5 for windows Without sub reports, it looks like you are going to have to create a temp table that you can populate to arrange the data in the way you want it displayed. It would need columns for Employenumber, skills, languages, and hours. 1. Get employee 2. make cursors for each or the 3 subsets 3. fetch from each of the cursors 4. if any of the 3 subsets retrieved data, push a record into report table 5.if no subset data left, go back to #1 Break the report on the employeenumber, and pull demographics in break header. detail section should show the subset data the way you want. Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Buddy Sent: Monday, April 01, 2013 10:25 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: report question in Version 6.5 for windows 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
