Can I use grouped field totals to filter report?
I have a report that is using two fields to group and sort the data and my only problem is, from that point on, I only want to show the entries where there is more than one record matching my grouping criteria.
In this particular case, we are using employees who are given assignments on event days. The purpose of the report is supposed to be to show when someone has been booked for more than one position (or job) on a single day. I am grouping and sorting the report by related employee and then by event date and that works perfectly but I would like to be able to say "if a group has only 1 record, do not show it in the report". I've tried using a summary table but did not like it because the grouping, sorting, and display options are not as helpful in displaying the information we would like in the report.
Does anyone know if we can use the totals from our grouped report to filter the table as well? If not, anyone have any other ideas either native or with code? Thanks!
In this particular case, we are using employees who are given assignments on event days. The purpose of the report is supposed to be to show when someone has been booked for more than one position (or job) on a single day. I am grouping and sorting the report by related employee and then by event date and that works perfectly but I would like to be able to say "if a group has only 1 record, do not show it in the report". I've tried using a summary table but did not like it because the grouping, sorting, and display options are not as helpful in displaying the information we would like in the report.
Does anyone know if we can use the totals from our grouped report to filter the table as well? If not, anyone have any other ideas either native or with code? Thanks!
