Hiding Panels

[Taras]

I have 3 panels in a report (using Standalone Designer R3 2021).

Corresponding to these panels, I have 3 fields in the data source V1Display, V2Display and V3Display.  The values in these fields are either 0 or 1, with 1 indicating the panel should be displayed.

I've tried different suggestions I've found in older threads and elsewhere to hide the panels based on Conditional Formatting or Binding.

How do I had a panel if its VxDisplay value = 0?

[Taras]

Can't seem to get it working with Conditional Formatting but this works for bindings:

[Taras]

Answer is in the comment section, repeating here

Can't seem to get it working with Conditional Formatting but this works for bindings:

[Neli]

Hi Taras,

Basically, we recommend using ConditionalFormatting. I attached a sample report that you can use a further reference.

[MasiULLAH]

Hi Neli

can u give any other references to using ConditionalFormatting are Binding to when value is zero it want to hide they occupy they space and when they value is 1 show they particular cell only 

I SHARED IMAGE 

 

[Dimitar]

The shared image seems to be that of a table. Please keep in mind that when hiding table cells, if there are other visible cells on the same table row, the space will remain occupied so that the tabular structure remains consistent.

With that being said, since you need to check whether the value is zero or one and hide the item in the former case, you can use the following binding:

If you need further assistance, please attach a copy of the report definition and sample data that we can use to preview the report locally, then tell us which item(s) you are trying to hide in the report and we will diagnose what are the possible approaches.

[MasiULLAH]

I SAHRED IMAGE IWANT HIDE WHEN IT ZERO BOTH THEY RED BORDER I HIGH LIGHTED WHEN ONE BOX GET VALUE SHOW THEY PARTICULAR BOX ONLY 

[Dimitar]

Did you try creating the binding on the Visible property for the textbox items as shown in the image of my reply?

I cannot offer more specific solution until seeing the report definition but as said earlier, when hiding some of the cells of a table row, the space will remain occupied unless the whole table row is hidden, plase keep that in mind.

If you need further assistance, attach a zip with the report definition file(TRDP, TRDX or CS) and sample data to preview the report locally.

[MasiULLAH]

I binded they value and its hide  but when i hide all they 5 rows and 2 line want to occcupy they space for sno 2 

[Dimitar]

I am not sure what you mean by saying "2 line want to occupy they space for sno 2", what is sno 2 referring to?

In the attached report, I see that the item textBox43 has the binding from the attached image but that is the only textbox on that row that has such a binding. You have to apply the biding for the other textbox items either individually, for example:

or to all textbox items in the row:

For example, you may hide the whole row when the sum of all fields on that row is null:

 

[MasiULLAH]

"How can I get continuous serial numbers (1, 2, 3, 4, etc.) in a grouped table with 12 columns? Currently, the 'Column()' is only displaying 1. How can I generate a proper serial number for the grouped table?"

[Dimitar]

You may check out my reply in the Serial Number in Reporting | Telerik Forums thread for the answer to this question.

[MasiULLAH]

 {"ItemList": [
    {
      "type": "object",
      "properties": {
        "SlNo": {
          "type": "string",
          "sas": 1,
          "maxLength": 6,
          "pattern": "^([0-9]{1,6})$",
          "description": "Serial No. of Item"}}
}]}

 

How to display they "SINO" Value in report and how to bind they nested value

   

[Ivet]

I noticed you asked the same question in a different forum thread. I have replied to your question there so please go to the following link to see my answer - Displaying sum of nested JSON data in a table using Telerik Designer in Reporting | Telerik Forums