Filtering on telerik reporting

[anamika]

I want to apply five filtering drop-downs on the table. But when i am adding 5 filters they are using AND filtering, which allows me to choose every filter in order to generate table. But i want to generate the table on every single filter. Ex - i have 5 filters - username, sports type, pay time , date and centre. If i select a username then the table will display all the users with that name without filtering other drop-downs. Please help me out to solve this problem. 

[Dimitar]

Hello Anamika,

Assuming you have set the filtering on the table level, the table will be re-generated every time that one of the values that filtering depends on gets changed. A case where the table might not get updated is if you are for example using a report parameter whose AutoRefresh value is set to False. In such a case, you have to click on the Preview button every time you update the report parameter in order to re-generate the table.

Regarding the statement - " If I select a username then the table will display all the users with that name without filtering other drop-downs", did you mean that you would like the values of the other four report parameters to be filtered by the first parameter value? If so, you may use Cascading Report Parameters:

• How to Cascade Parameters with applied filtering on Report level
• How to Cascade Parameters with applied filtering on data source level

If you can't figure out what's the problem, please send us a sample project alongside some sample data, preferably in JSON or CSV format, so that we can inspect it locally. Also, please correct me if I have misunderstood something about your issue.

Regards,
Dimitar
Progress Telerik

[anamika]

Thanks Dimitar.

I have attached a screenshot here that will help you to understand my problem.

Here in this screenshot, I have 6 filters , two date type and four of dropdowns, I have already selected the dates now i want to show the data only on the basis of dates, I don't want to select other dropdown filters. So is it possible for me to only select through them if I don't want to select other four dropdowns.

[Neli]

Hi Anamika,

You may test setting the Visible property to False of the dropdown parameters. In this case, when you preview the report, they will not be shown.

I hope this information will help you. Please, let us know if you need further assistance.

Regards,
Neli
Progress Telerik