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

Filtering on telerik reporting

3 Answers 32 Views
Report Designer (standalone)
This is a migrated thread and some comments may be shown as answers.
anamika
Top achievements
Rank 1
Veteran
anamika asked on 22 Feb 2021, 07:35 PM
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. 

3 Answers, 1 is accepted

Sort by
0
Dimitar
Telerik team
answered on 25 Feb 2021, 04:56 PM

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:

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

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

0
anamika
Top achievements
Rank 1
Veteran
answered on 04 Mar 2021, 05:23 AM

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.

0
Neli
Telerik team
answered on 08 Mar 2021, 02:23 PM

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

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

Tags
Report Designer (standalone)
Asked by
anamika
Top achievements
Rank 1
Veteran
Answers by
Dimitar
Telerik team
anamika
Top achievements
Rank 1
Veteran
Neli
Telerik team
Share this question
or