This is a migrated thread and some comments may be shown as answers.

Parameters that work independently with filters

1 Answer 168 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Chandrak
Top achievements
Rank 1
Chandrak asked on 27 Mar 2017, 02:56 PM

Hi,

I have relational data in State & City format. Using reports parameters I see these issues.

(1) I can not have parameter having "ALL" in state parameter as selection and based on that cities selected automatically.. if any coding needed I dont know and not interested.

(2) I can not have only single State selection as I must select filtered city or cities to send it to report filter to get data only for the city.. I do not want customer to select multiple states.. as of no use in my case

so here is what I am looking..

By default report launch will ALL data

(1) one parameter for state (combo box) where single selection will be done and based on it applied filter will work on the report data

(2) have two parameters for state (single selection combo box) and City (single selection combo box)..based on selected state.. all cities will be listed and user chooses single city and that will work on different filter ..

is this possible at all? I mean independent parameters working on report data using independent filters?

 

Regards

 

1 Answer, 1 is accepted

Sort by
0
Katia
Telerik team
answered on 29 Mar 2017, 03:13 PM
Hi Chandrak,

Reporting expression engine has been extended with AllValues and AllDistinctValues aggregate functions that can be used as default value for multivalue report parameter. This will allow to have all values selected as default value in multivalue report parameter.
If you are interested in this functionality you need to upgrade to the latest internal build. It can be downloaded from your Telerik account - Downloads - Reporting.

It is possible to have independent report parameters as well as cascading parameters. To apply filter rules based on the values of report parameters you can follow Filter Rules help article.


Regards,
Katia
Telerik by Progress
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
General Discussions
Asked by
Chandrak
Top achievements
Rank 1
Answers by
Katia
Telerik team
Share this question
or