Liveware Publishing Support Forum

How to ensure record is printed for employee even though there isn^t any record within LEAVE_TAKEN?____I have 2 tables __- Employee_List (Structure: Emp_No, Emp Name)____Record details in Employee List__-------------------------------__Emp1, Alice__Emp2, Nathan__Emp3, Peter____- Leave_Taken (Structure: Emp_no, Lv_cd, Lv_from, Lv_to, lv_day)____Records details in Leave_taken__------------------------------__Emp1, AL, 01/02/2005, 01/03/2005, 2__Emp1, AL, 03/01/2005, 03/01/2005, 1__Emp3, AL, 02/10/2005, 02/10/2005, 1______Result obtain__-------------____Name Leave Details Days Taken__Alice AL 01/02/2005 to 01/03/2005 2 __Alice AL 03/01/2005 to 03/01/2005 1 __ Total: 3____Nathan <--- this is missing__ Total: 0 <--- this is missing____Peter AL 02/10/2005 to 02/10/2005 1__ Total: 0____This is what I do:__1) Created Employee_List as a Master Table__2) Create Relation to Leave_Taken -> using emp_no from Employee_list, Relation Type - set to Scan, Character Match - set to Partial Len 4__3) GROUP function is not active in Relations option. ____I^ve read about the Scan Groups function. However I can^t seem to activate the Group function.____I am using R&R v6.5 Xbase edition____Thank you very much________

You need to edit the relation click the options button and then change the failure action in the lower right of the dialog from Skip to Blank.____Kathleen__R&R Support

:-) Appreciate your reply.____Change Failure action from SKIP to BLANK as suggested. Result still the same - record for Nathan is still missing.____I have only 2 band line in the report - Record and 1GF_EmpNo. __________

Do you have query in the report?____Kathleen__R&R Support

Yes, I have a Query from the 2nd table.... I notice that once I added the Query, the records started to disappear. You mean I cannot? ____Does that mean instead of using QUERY, I have to __1) Use a calculated field to extract necessary information?__and/or__2) Use a conditional printing to exclude redundant records?____I also do not have an EXACT index between the controlling table and the scanned table ie. I am using SCAN -> Partial Length option. Will it also be the cause of problem?____I feel that I am getting closer to the root of my problem. __;-) Thank you very much.

A conditional print instead of the query would indeed be the easiest way to solve this.____Kathleen__R&R Support