We are trying to run the above report and the results we get are incorrect. it seems the pjtran table is correct but the total of labor hours for one period are not posted in the views that the above report uses. So for example, if we find the total labor hours by SQL query from PJTRAN for a bunch of employees it yields a correct result. However if we run the above report, it produces the correct report hours total minus the initial period. Is there something to be done to sync up the views this report uses with pjtran to produce the correct results?
*This post is locked for comments