topic Multi Tier Reporting Solution Help in ArcGIS Pro Questions https://community.esri.com/t5/arcgis-pro-questions/multi-tier-reporting-solution-help/m-p/246435#M10845 <HTML><HEAD></HEAD><BODY><P>I'm trying to figure out how to do reporting based on work orders coming from workforce, joined to survey123 data.</P><P></P><P>I need the report to spit out the following:<BR /><BR />Work Order Details (WorkOrderID, AssignmentType, Date, Status, Description, Assignments)</P><UL><LI>Labor Detail (Person, Hours, Rate)</LI><LI>Material Detail (Material, Quantity, Cost)</LI><LI>Equipment (Equipment, Quantity, Cost</LI></UL><P>*each of the above bullet points would be a list of each of the people, material, equipment used and then summarizing their costs. This would then repeat for each Work Order.<BR /><BR />So a page from the report might look like:<BR /><BR />Work Order ID 35000, Fence Maintenance, 9/20/20, In Progress. Description</P><P>Labor Detail</P><UL><LI>Bill, 5 hours, $10/hr, $50</LI><LI>Steve, 12 hours $10/hr, $120</LI></UL><P>Material Detail</P><UL><LI>Paint, 10 units, $2, $20</LI><LI>Nails, 100 units, $5, $500</LI></UL><P>Equipment</P><UL><LI>Nail Gun, etc, etc</LI><LI>Paint Sprayer, etc, etc</LI></UL><P></P><P>Anything to help me get started with doing this in Pro would be helpful.&nbsp;</P></BODY></HTML> Mon, 28 Sep 2020 01:05:08 GMT PayneRingling 2020-09-28T01:05:08Z Multi Tier Reporting Solution Help https://community.esri.com/t5/arcgis-pro-questions/multi-tier-reporting-solution-help/m-p/246435#M10845 <HTML><HEAD></HEAD><BODY><P>I'm trying to figure out how to do reporting based on work orders coming from workforce, joined to survey123 data.</P><P></P><P>I need the report to spit out the following:<BR /><BR />Work Order Details (WorkOrderID, AssignmentType, Date, Status, Description, Assignments)</P><UL><LI>Labor Detail (Person, Hours, Rate)</LI><LI>Material Detail (Material, Quantity, Cost)</LI><LI>Equipment (Equipment, Quantity, Cost</LI></UL><P>*each of the above bullet points would be a list of each of the people, material, equipment used and then summarizing their costs. This would then repeat for each Work Order.<BR /><BR />So a page from the report might look like:<BR /><BR />Work Order ID 35000, Fence Maintenance, 9/20/20, In Progress. Description</P><P>Labor Detail</P><UL><LI>Bill, 5 hours, $10/hr, $50</LI><LI>Steve, 12 hours $10/hr, $120</LI></UL><P>Material Detail</P><UL><LI>Paint, 10 units, $2, $20</LI><LI>Nails, 100 units, $5, $500</LI></UL><P>Equipment</P><UL><LI>Nail Gun, etc, etc</LI><LI>Paint Sprayer, etc, etc</LI></UL><P></P><P>Anything to help me get started with doing this in Pro would be helpful.&nbsp;</P></BODY></HTML> Mon, 28 Sep 2020 01:05:08 GMT https://community.esri.com/t5/arcgis-pro-questions/multi-tier-reporting-solution-help/m-p/246435#M10845 PayneRingling 2020-09-28T01:05:08Z