Can't seem to filter

1 Answer 91 Views
Filtering Report Designer (standalone)
Joe
Top achievements
Rank 1
Joe asked on 13 Jan 2023, 10:48 PM

So, I have a report that I can't seem to filter. I want to filter the report based on the SalesCode.

I absolutely know that SalesCode "LB040" exists, but my report is blank when I run it. If I delete the filter, the report shows all the SalesCodes.

Am I formatting it wrong? Is it in the wrong group? I've tried filtering the StopGroup, but that didn't help.

Thanks for the help!!!

 

 

 

1 Answer, 1 is accepted

Sort by
0
Momchil
Telerik team
answered on 18 Jan 2023, 03:21 PM

Hello Joe,

Thank you for the provided screenshots.

From what I can see, your filter is correct.

That being said, if you want to filter the records of a report, you do not need to filter its groups, and can apply the filters directly to the report using the properties window, as you have done in the last screenshot (See Filtering Data Overview for additional information).

With that out of the way, here are some general reasons that could explain why the filter does not match any records:

  • The value of the "SalesCode" field might contain leading or trailing spaces. If that is the case, trimming the value using the Trim function should resolve the issue. 

  • Is the value supposed to be "LB040" (with zeroes), or "LBO4O" (with capital O's)?

In case the suggestions above do not help, you can provide the report definition along with some sample data in CSV or a JSON data source, and we will investigate it locally.

As a side note, I would like to add that the Value field of the Edit Filters window treats the value you pass to it as a string by default, so you can type LB040 directly.

Best Regards,
Momchil
Progress Telerik

Brand new Telerik Reporting course in Virtual Classroom - the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products. Check it out at https://learn.telerik.com/.
Tags
Filtering Report Designer (standalone)
Asked by
Joe
Top achievements
Rank 1
Answers by
Momchil
Telerik team
Share this question
or