Is there a way for qr codes not to be displayed if the value of the field is null?

[Roberto]

Hello. I'm creating a report that contains qr codes in columns. The qr codes are displaying well, but if one of them is null, also is displayed. I'm trying to use conditional formatting, but if I uncheck "visible" in layout style, nothing is displayed in the column (background, borders...). I use another conditional formatting for alternating rows.

Thank you.

[Todor]

Hello Roberto,

I noticed that you have opened a support ticket for the same issue. I will summarize our reply here for the benefit of our community.

The observed behavior is expected, as the Styling is applied to report items (e.g. TextBoxes, Barcodes), and table cells are something like placeholders for report items. When you hide the Barcode all the formatting will disappear and cell will be displayed as blank.

To avoid this behavior you may use a Panel in the cell and place the Barcode item inside the Panel. You may apply the (conditional) formatting that should be visible even when the Barcode is hidden to the Panel and set conditionally the Visible property only of the Barcode.

Check the attached report that demonstrates the approach. The sample will work with version 13.2.19.1004 and above as it uses JsonDataSource with Null values. However, the approach is generally applicable for older versions of our Reporting tool.

Regards,
Todor
Progress Telerik

[Roberto]

Hello Todor.

Thanks for answering. I'm sorry I asked the question in two different places, I didn't know how to do it. I will try the panel solution, although I think the report should not show anything if the linked field has no value or the value is null. It only happens in QR and PDF417 barcodes.

Best regards.