Value Headers Shown Only With Value Follow
For our labels we take the format of having certain fields of our items, followed by the actual values, an example would be:
Item code: 12345
Commercial name: "name"
Now in order to link these values more directly to our system, we have linked these values to an Excel document. However, not all our products have all of these values, some for instance do not have a quality definition. Is it possible to have a query or function that would allow for the Field names such as Quality, or Type, to only be displayed if there is an actual value in the field? Or if the value is for instance greater than 0?
Please sign in to leave a comment.