Skip to Content
0
Former Member
May 28, 2008 at 05:46 PM

shared variable or subreport

22 Views

Post Author: skootsu

CA Forum: Formula

Fairly CR newbie here hoping someone can help me. I have to get a report listing 'Labor Efficiency Summary for week ending' by department by employee. I have all the info needed in tables Employee (name), Labor_Ticket (Type, Dept, Workorder, LotID, OpSeq, Emply, Time reported), and Operation (workorder, LotID, OpSeq, Routed Time). For the main report I have all reported labor reported grouped by Dept/Emply. I have in the GF1 the Department, sum Work hours and sum Indirect. In GF2 I have Employee, Sum Hours logged, and Sum Indirect Total. In the details I have WorkOrder,LotID, OpSeq, Dept, Ticket hours worked, Indirect Hours. In the RF I have a subreport of all operations. Grouped by Operation.Workorder_ID, Operation.Workorder_Lot_ID, Operation.Sequence_No. Everything is supressed except the GF3 which has Workorder_ID, Lot_ID, Operation_Seq_No, Total Hours. So, I have a couple of problems. One, how to get the Total Hours from the Operations sub report to display in the details of the main report? Second, since the labor tickets table contains All labor reported, I need only those where the Workorder,lotID and operations Seq no match. Any tips? I tried linking the subreport, these fields but I don't think thats what I need here. There should be no prompting just link to the subreport to get the necessary total for the main report. I have never done a Shared variable but looking around I'm thinking this sounds like what I need. Any ideas to get me over this hump? Thanks