web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Filter on Report is no...
Small and medium business | Business Central, N...
Suggested answer

Filter on Report is not working

(0) ShareShare
ReportReport
Posted on by Sarath9999 50

Hi All,

           I am doing a report in that I am giving the  setfilter value true for only advance invoice field, but in the report it is taking the false value of the advance  invoice field, In the report filters also I am setting the advance invoice field to true, but from that filter also it is taking the false value only, can anyone help me.

pastedimage1678371983500v1.png

pastedimage1678372046031v2.png

Thanks & Regards

I have the same question (0)
  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 60,977 Super User 2025 Season 2 on at
    RE: Filter on Report is not working

    try

    Setrange("Advance Invoice", true);

    Setfilter("Remaining Amount", '<>0');

  • Sarath9999 Profile Picture
    Sarath9999 50 on at
    RE: Filter on Report is not working

    Hi Mohana,

             I tried the setrange but it is also not working, it is showing the advance invoice false values only.

    Thanks & Regards,

    Satish.

  • Suggested answer
    NAV_with_Narang Profile Picture
    NAV_with_Narang 2,250 Moderator on at
    RE: Filter on Report is not working

    Instead of SETRANGE on OnPreDataItem, you can use the below Data Item property

    Illustrations/Documents:

    https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/properties/devenv-dataitemtableview-property 

    pastedimage1678376827498v1.png

      dataitem("Purchase Header"; "Purchase Header")
    {
        DataItemTableView = SORTING("Document Type", "No.") WHERE("Document Type" = CONST("Blanket Order"));
    }

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Sumit Singh Profile Picture

Sumit Singh 2,179

#2
OussamaSabbouh Profile Picture

OussamaSabbouh 1,999

#3
YUN ZHU Profile Picture

YUN ZHU 1,892 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans