Home
Designing Analytics Reports
Is it possible to group by a field, then show all records for that field in the details?
Migrateduser
<p>I have a table that has a list of work orders, the day the work is scheduled to be done, and employee names assigned to do the work. Some work orders have multiple employees assigned to work on the same day. </p>
<p> </p>
<p>Work order Date Name</p>
<p>3002 6/22/17 Smith</p>
<p>3002 6/22/17 Anderson</p>
<p>3007 6/22/17 James</p>
<p>3009 6/23/17 Smith</p>
<p>3014 6/23/17 Anderson</p>
<p>3014 6/23/17 James</p>
<p> </p>
<p> </p>
<p>I have a report that groups by the Name, but I want to be able to show all employees names in the details section so the employee can see who they are working with that day. </p>
<p> </p>
<p>I want it to look like this:</p>
<p> </p>
<p>Anderson</p>
<p>3002 6/22/17 Anderson, Smith</p>
<p>3014 6/23/17 Anderson, James</p>
<p> </p>
<p>Smith </p>
<p>3002 6/22/17 Anderson, Smith</p>
<p>3009 6/23/17 Smith</p>
<p> </p>
<p> </p>
<p>So far, because of how grouping works, I am not able to accomplish this. Any way around it?</p>
Find more posts tagged with
Comments
There are no comments yet