Author Topic: Filtering for Charts  (Read 320 times)

Offline Richard1977

  • Full Member
  • ***
  • Join Date: Jan 2016
  • Posts: 14
  • Forum Citizenship: +0/-0
Filtering for Charts
« on: 22 Sep 2017 05:41:46 am »
Good Morning
I wonder if anyone can answer a I have about active reports.

I am a report developer using report studio for many years but I am currently designing my first active report, I want to be able to filter numerous items by a data radio check buttons. I have set all the lists to be controlled by them and they work fine, however somebody has asked me to include a couple of charts. I have added them but the issue is when I try create a connection between the radio buttons and the charts, it only offers me the select option

So my question is can you filter charts the same way you can lists?

Many thanks in advance for any help

Regards
Richard

Offline hespora

  • Statesman
  • ******
  • Join Date: Nov 2015
  • Posts: 348
  • Forum Citizenship: +22/-0
Re: Filtering for Charts
« Reply #1 on: 22 Sep 2017 06:43:44 am »
No, you cannot. There's two things you can do:

a) ditch charts in favor of visualizations.
b) stick a chart inside a data deck and setup master-detail relationship. controls *select* rather than filter the data deck's cards, which show different versions of the chart, which in turn looks like filtering.

Offline Lynn

  • Statesman
  • ******
  • Join Date: Apr 2008
  • Posts: 2,565
  • Forum Citizenship: +332/-1
Re: Filtering for Charts
« Reply #2 on: 25 Sep 2017 02:59:20 am »
Hespora is on the money with those two options.

If you go with option "b" and have many different versions of charts, you may find the overall size of the MHT to be larger than desirable. There is no charting engine for traditional charts, so each possible iteration will be pre-rendered (as an image) in the file. If there are only a couple possible chart displays then this is less of an issue.

Option "a" will load the visualization engine, which is a small overhead, but than many different visualizations with numerous filter options can be included with much less impact on the overall file size. As an added bonus, visualizations have animation properties which allows for a more appealing user experience.

Offline Richard1977

  • Full Member
  • ***
  • Join Date: Jan 2016
  • Posts: 14
  • Forum Citizenship: +0/-0
Re: Filtering for Charts
« Reply #3 on: 25 Sep 2017 11:04:43 am »
Thank you Lynn and Hespora for your options.

I will try these option A because the active report will have several charts that need filtering, so size may be an issue

Thank you again for your help

 


       
Twittear