I created a report that displays records that are either Status "Active" or Status "Monitoring." They are sorted and grouped to show Active records at the top. I have applied conditional formatting to the grouping header that lumps together records that are all due in the same week. This brings up two questions.
1. Sometimes Active records don't have a due date, they are then lumped at the top of the report and the grouping header simply displays #Error. Can I apply conditional formatting to remove the #Error, possibly by using white text when #Error is present?
2. Because Monitoring records rarely have a due date (but sometimes do), can the control source or sorting and grouping heading that sorts by dates be removed only on the grouping heading that = Monitoring?
Any help or suggestions would be greatly appreciated.
-JDuguid in Detroit
1. Sometimes Active records don't have a due date, they are then lumped at the top of the report and the grouping header simply displays #Error. Can I apply conditional formatting to remove the #Error, possibly by using white text when #Error is present?
2. Because Monitoring records rarely have a due date (but sometimes do), can the control source or sorting and grouping heading that sorts by dates be removed only on the grouping heading that = Monitoring?
Any help or suggestions would be greatly appreciated.
-JDuguid in Detroit
