Suppressing a row when the row above it is suppressed without naming rows individually
My report uses spacer rows between sections for visual spacing. I need to suppress a spacer row whenever the row directly above it is also suppressed, otherwise I get uneven gaps.
The problem: I have hundreds of rows, so writing conditional suppression that names each row individually isn't feasible. I've thought about using grouping, but that would mean creating and managing hundreds of groups, seems like overkill.
Is there a way to reference "was the previous row suppressed?" generically, without hardcoding row numbers, that scales across a large report? Open to alternatives to grouping if there's a better way for this.
Tagged:
0