Action on graph to filter table data - Toggle

0 Answers 43 Views
Actions Filtering Report Designer (standalone)
Marvin
Top achievements
Rank 2
Veteran
Iron
Marvin asked on 07 May 2022, 09:49 PM

I'm trying to make a graph interactive so that the table below shows the values for the column I clicked in the graph.

In my attached example "Graph-Table" I want the following to happen:

  1. Click on the bar 3/2019
  2. Only the 2019 group shows in the table below. All the rest of the years are hidden
  3. Click on the bar 1/2018
  4. Only the 2018 group shows in the table below. All the rest of the years are hidden

In the attached report, you see I tried adding some interaction, but I don't know how to get it to toggle/filter the data.

Marvin
Top achievements
Rank 2
Veteran
Iron
commented on 11 May 2022, 11:50 AM

In addition or as an alternative I'd like to be able to use the interactive tool to filter an embedded subreport, but I can't find a way to do that either. Same type of situation as above, but rather than a local table, use a subreport. I don't want the user to need to go out of the current report to see the drilled down info.
Neli
Telerik team
commented on 12 May 2022, 11:31 AM

Hi Marvin, 

You can use a NavigateToReport Action and update the report once the user has clicked on a group. To filter the data, you need a report parameter. Its value will be passed to the filter.

I attached the updated report. Please, test it and let me know how it goes.

Marvin
Top achievements
Rank 2
Veteran
Iron
commented on 12 May 2022, 11:53 AM

Thank you! That's exactly what I ended up doing, but I don't like the idea of reopening the report every time. I want to navigate and stay within the same report. 

Why?

1. Because it takes time to render the report again, and I don't like the delay.

2. I want it to be smooth action, where you don't have the user waiting for the report to respond.

If I could filter the table in the embedded subreport, and not go outside of the current page, it would help a lot. I haven't found a way to send an interactive parameter to an embedded subreport.

Thanks again for answering and sending the sample. Any other ideas out there?

 

Neli
Telerik team
commented on 17 May 2022, 10:41 AM

Hi Marvin,

Thank you for your update. In general, once you change the value of the parameter, then the whole report will be rerendered. This behavior is by design. The same is applied with most of the actions. I am afraid that there is no workaround that I can suggest. 

No answers yet. Maybe you can help?

Tags
Actions Filtering Report Designer (standalone)
Asked by
Marvin
Top achievements
Rank 2
Veteran
Iron
Share this question
or