Report Desginer - Hide a Panel in Telerik Report Designer Based on Table Data

Hello, Leo,

If you want to control the visibility of a report item based on the data, the perfect fit is to use the conditional formatting functionality: Conditional Formatting Overview. Follow the steps:

1. Create a report parameter (boolean type) which value is bound to the specific data source value. It may be necessary to apply an appropriate expression according to the specific requirement you have. Here is the report parameter:

2. Then, using the report parameter's value, set up a conditional formatting rule such that when the value of a Report Parameter <> true, it applies a format where visibility is disabled. In other words: if the ReportParameter value is not equal to true, make the report item invisible.

The Conditional Formatting Rules dialog lets you define rules, that when fired, change the style formatting of the selected item.

The above example can be extended further in a way to apply a more complex expression instead of the value of the report parameter: Using Expressions in Conditional Formatting

Another option to consider is using a report parameter with AvailableValues bound to the exact data values from the source which control the visibility. 

I hope you find this information helpful. Please, let me know if there is anything else I can assist you with.

Regards,
Dess | Tech Support Engineer, Principal
Progress Telerik

Hi, Leo,

If I understand you correctly, you need to show/hide the table with the JSON data based on specific records in the collection. I have further extended my sample report to simulate as close as possible the desired scenario.

Let's consider we have a collection of books and we want to hide the table if two specific books ("Nostromo", "Stories") are published in 1904 for example. Here is my JSON:

[
   {
    "author": "Miguel de Cervantes",
    "country": "Spain",
    "imageLink": "images/don-quijote-de-la-mancha.jpg",
    "language": "Spanish",
    "link": "https://en.wikipedia.org/wiki/Don_Quixote\n",
    "pages": 1056,
    "title": "Don Quijote De La Mancha",
    "year": 1610
  },
  {
    "author": "Geoffrey Chaucer",
    "country": "England",
    "imageLink": "images/the-canterbury-tales.jpg",
    "language": "English",
    "link": "https://en.wikipedia.org/wiki/The_Canterbury_Tales\n",
    "pages": 544,
    "title": "The Canterbury Tales",
    "year": 1450
  },
  {
    "author": "Anton Chekhov",
    "country": "Russia",
    "imageLink": "images/stories-of-anton-chekhov.jpg",
    "language": "Russian",
    "link": "https://en.wikipedia.org/wiki/List_of_short_stories_by_Anton_Chekhov\n",
    "pages": 194,
    "title": "Stories",
    "year": 1886
  },
  {
    "author": "Joseph Conrad",
    "country": "United Kingdom",
    "imageLink": "images/nostromo.jpg",
    "language": "English",
    "link": "https://en.wikipedia.org/wiki/Nostromo\n",
    "pages": 320,
    "title": "Nostromo",
    "year": 1904
  },
  {
    "author": "Charles Dickens",
    "country": "United Kingdom",
    "imageLink": "images/great-expectations.jpg",
    "language": "English",
    "link": "https://en.wikipedia.org/wiki/Great_Expectations\n",
    "pages": 194,
    "title": "Great Expectations",
    "year": 1861
  }
]

Add a report parameter "SpecificRecords" which is populated with the same JSON collection. However, we will filter the collection with the specific records. These specific records should be known and they are books "Nostromo", "Stories" in our example. The second condition in the filter rule is the year is equal to 1904.

It is important that the parameter allows null values.

The next step is to add a conditional formatting rule based on the report parameter with specific values and check if there are any values to hide the table:

I have attached the extended .trdp report. When you preview it in the designer, the SpecificRecords parameter is expected to be marked as NULL and table3 should be hidden:

If we modify the values in the JSON data source and change the year for the specific books as follows:

Then, one book will be shown in the report filter and the condition for hiding the table wouldn't be matched. The table will be displayed:

Note that this report parameter shouldn't be visible as it depends on the data records and the end user is not expected to manipulate it.

Please give the sample report a try. Feel free to further modify and extend it according to your needs.

Regards,
Dess | Tech Support Engineer, Principal
Progress Telerik