# Custom Report filter not working properly **URL:** \ **Category:** Uncategorized\ **Created:** [July 10, 2020, 1:12am UTC](https://forum.manager.io/t/custom-report-filter-not-working-properly/29286 "2020-07-10T01:12:17Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![San\_Thida\_Myo\_Latt](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/san_thida_myo_latt/32/16513_2.png) [@San\_Thida\_Myo\_Latt](https://forum.manager.io/u/San_Thida_Myo_Latt)\ **Post date:** [July 10, 2020, 1:12am UTC](https://forum.manager.io/t/custom-report-filter-not-working-properly/29286/1 "2020-07-10T01:12:17Z")
![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/8/f/8fd98ca58a95b8fa7299a2543bc6b0e57ac5fd39.png) filter with Sales Invoice\>\> Custom Field \>\> not include" Cancel" But result showing "Cancel " ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/a/9/a9eea7468d91a4efcc9b017f0bc83ddbe8272728.png) @lubos is this possible to allow user to use Old Custom Report and New Custom Report for us, we had a lot of old custom reports and those are not working well at new version Thanks for your kind consideration ---
**Author:** ![alasdair](https://avatars.discourse-cdn.com/v4/letter/a/fbc32d/32.png) [@alasdair](https://forum.manager.io/u/alasdair)\ **Post date:** [July 10, 2020, 11:03am UTC](https://forum.manager.io/t/custom-report-filter-not-working-properly/29286/2 "2020-07-10T11:03:47Z")
FWIW - I haven’t hit the issue of a where clause not working but you are certainly not alone struggling with the new custom reports. While they clearly do some things better (multiple level grouping etc.) they have a much limited scope supporting only a transaction and date range focus… I too would love to see old reports supported until the new reports can cover more of the things the old could - e.g. non-transaction based queries etc. @Lubos - I suspect you did some table structure changes here but would it not be possible to create a “view” in the database that equates to the old GL transactions table against which old reports could continue to run? ---
**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\ **Post date:** [July 10, 2020, 12:26pm UTC](https://forum.manager.io/t/custom-report-filter-not-working-properly/29286/3 "2020-07-10T12:26:32Z")
Does the last field in your third filter by chance include an invisible character, such as a space? The filters are completely literal. ---
**Author:** ![Davide](https://avatars.discourse-cdn.com/v4/letter/d/258eb7/32.png) [@Davide](https://forum.manager.io/u/Davide)\ **Post date:** [July 10, 2020, 12:37pm UTC](https://forum.manager.io/t/custom-report-filter-not-working-properly/29286/4 "2020-07-10T12:37:06Z")
> [@alasdair](#): > > I suspect you did some table structure changes here but would it not be possible to create a “view” in the database that equates to the old GL transactions table against which old reports could continue to run? I suspect it too since the old report that were still visible had so many missed fields. So I put my soul in peace and deleted them all ---
**Author:** ![Davide](https://avatars.discourse-cdn.com/v4/letter/d/258eb7/32.png) [@Davide](https://forum.manager.io/u/Davide)\ **Post date:** [July 10, 2020, 12:38pm UTC](https://forum.manager.io/t/custom-report-filter-not-working-properly/29286/5 "2020-07-10T12:38:28Z")
> [@Tut](#): > > Does the last field in your third filter by chance include an invisible character, such as a space? The filters are completely literal. I’ve esperinced it too. Also there are many issues in sortings… especialy with dates when set as second setting for ordering. ---
**Author:** ![San\_Thida\_Myo\_Latt](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/san_thida_myo_latt/32/16513_2.png) [@San\_Thida\_Myo\_Latt](https://forum.manager.io/u/San_Thida_Myo_Latt)\ **Post date:** [July 10, 2020, 3:11pm UTC](https://forum.manager.io/t/custom-report-filter-not-working-properly/29286/6 "2020-07-10T15:11:52Z")
Thanks Yep, there is white space and after removing, it’s working well now. ---
**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\ **Post date:** [January 18, 2023, 2:54pm UTC](https://forum.manager.io/t/custom-report-filter-not-working-properly/29286/7 "2023-01-18T14:54:54Z")
Closed on January 18, 2023, 2:54pm UTC