Search results for query: *

brian, I have made my report very basic to solve my problem. I have no conditions. It seems like my left outer join is not working. I get all of my equipment IDs from the eqiupment master table but none from the time card. I have not yet put the null is a condition so I could debug the...

One thing I have found out, is on my time card I have payroll records and equipment records. On my report I am getting the payroll records with the null value. I have fixed this my using another condition that removes the payroll records. I am going to play around with it some more. I think...

I took off the sort and no change. I added the equipment ID from the Time card and they are all blank. Jeff

SELECT EC_EQUIPMENT_MASTER."Equipment_Code", EC_EQUIPMENT_MASTER."Location", PR_PRE_TIME_CARD."Equipment_Code" FROM { oj "EC_EQUIPMENT_MASTER" EC_EQUIPMENT_MASTER LEFT OUTER JOIN "PR_PRE_TIME_CARD" PR_PRE_TIME_CARD ON EC_EQUIPMENT_MASTER."Equipment_Code" =...

bdreed35, I followed your steps and I am getting records that are on both tables. I added the equipment ID from the Equipment master table to my report to view. Any suggestions?

I am trying to build an exception report that shows the pieces of equipment from the master list that have not been coded in the time card table. Table 1: Equipment master Table 2: Time Card They both have an equipment ID on them. Any help would be appreciated. Jeff