I want to set up a conditional format to hide an image if the byte array count < 2. I cannot figure out how to simply deal with collections such as arrays and get a count.
I've tried this, but my report won't preview in the designer:
How do I achieve this?
Thanks in advance.
The equals sign should only be used at the start of the expression(unless you need to actually check for equality in the expression), there is no need to also have it before Fields.[Logo] so the expression could be changed to the following: =Count(Fields.[Logo]).
With that being said, you could instead try to get the Length property of the array - Fields.[Logo].Length
Indeed, currently, if the PictureBox has an invalid value, it will error out. Creating a user function that always returns a valid image, is what I would also recommend in this case.
You may be interested in the following feature requests:
- Allow disabling picturebox errors via "ShowErrors = false"
- Show a picturebox of which the url is unavailable as a red cross instead of destoying the complete report layout.