The battle with Crystal never ends.
So, I've got a report that is working great, even exporting to excel (data only) where all the data is in the cells I expect them to be. However, I just noticed that some of the rows that were suppressed appear in the excel output. What the heck?
Any workarounds or solutions to this?
... enterprise solution <-- uh huh.
Fastest problem solved all week
... so, the way to fix this is this.
If you encounter this problem, it may be because the suppression logic is applied to the start of a Row Group such as Group 4, Group 4a, Group 4b, etc. and your suppression logic is only in Group 4. The logic needs to be applied to all of the individual sections in order for the excel output to be correct.
Yay for enterprise solutions