All you report experts, this should be an easy one. I have a report with a field that may or may not contain a value (ie. a comment) The spacing remains on the report whether it contains a value or not.
What is the easiest way to shrink the space if comment.value =""
I tried using something similar to the change order but was not successful.
You need to give us more to work with. Report editor? Screen shot of problem area? Fields you are working with? Couple of answers come to mind such as âconcat those stringsâ or âminimize field height but set for autogrowthâ, but they are all situation dependent.
Itâs a report that has a comment field. I am working in SRSS. There may or may not be a comment. Currently the field is in the report but creates whitespace if the field has no value. This can extend a report that has 10 lines and only one comment.
Yep, I agree with @ckrusen on his comment regarding
If the comment field is on itâs own row in the tablix, then you can right click on that row and adjust itâs âRow Visibilityâ based on an expression.