Liveware Publishing Support Forum

I am trying to create a report that shows all employees billing by location. I sorted my data by employee and location and have a group header for the employee name and id. Also, I created a group footer for the location with some dollar amounts totaled by location.____My question is how can I show only those employees who have billing in more than one location?____TIA,____Mike

Create a total that counts location, accumluates once per location and resets by employee.__Make this total pre-processed. You can then use this field in the query and only select records where its value is greater than 1.____Kathleen__R&R Support