If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Filtering for Charts

Started by Richard1977, 22 Sep 2017 05:41:46 AM

Previous topic - Next topic

Richard1977

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

hespora

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.

Lynn

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.

Richard1977

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