By using this website, you agree to our Terms of Use (click here)
I have a report showing inventory lines, I am trying to hide all rows who summarize out to 0 (not in stock and/or perfectly balanced).
My visible expression for the group header section is simply "=$Balance<>0". When I run this report, the rows are blank, but still take up "space" as if they existed. So my report is massive and I have large gaps of whitespace in between some rows now. Thoughts on how this occurs and what I can do to fix it?
Thanks,
Edit: I can attach the report if need be, however it compiles from a custom-built view and won't be usable outside of seeing the report structure.
Well I found my error. When you try to hide a group, ensure you also hide the footer of that group. I only placed my visibility expression in the header segment. My footer was as collapsed as I could make it, but it apparently still has a height behind the scenes and it adds up over many "blank" rows. I simply set my footer (which is empty) to never being visible. Going forward, I think I may hide all segments who are not being used to avoid issues.
Interesting. I guess even 1 or 2 pixels can add up to a lot of whitespace over multiple records.