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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / filter in the report
Microsoft Dynamics NAV (Archived)

filter in the report

(0) ShareShare
ReportReport
Posted on by snoppy 4,824

Hi expert, I have a question. I have added an extra field in the item table and filled out the data. Then created a new report based on the table. When running the report, I could select the item no from the dropdown list of No filter, but not the new field I created and I had to  enter the value. How to select the value from the list instead of  entering the value? Thank you!

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Nareshwar Raju Vaneshwar Profile Picture
    Nareshwar Raju Vane... 5,596 on at

    Hi,

    Did you try creating a new table and move the new field data in a <key, value> pair and in the Item Table, giving the TableRelation to the newly created table?

    Hope it helps.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Have you defined any "Table Relation" Property for that newly created field?

  • Suggested answer
    RockwithNav Profile Picture
    RockwithNav 9,021 Super User 2026 Season 1 on at

    Hey Snoppy,

    Just copy and paste the Table Relation Property of the No Field to the one you newly created. It will work for sure as you are expecting.

  • snoppy Profile Picture
    snoppy 4,824 on at

    But I created the new field in the same table (Item table). How do I define the table relationship?

    Do I really need to create a new table and move the data to the new table and then create the relationship with the Item table in order to do that? Thank you!

  • Suggested answer
    RockwithNav Profile Picture
    RockwithNav 9,021 Super User 2026 Season 1 on at

    Hey Snoppy,

    No Issue even if you created the field in the Item Table. Just give the lookup of the Item No it will work.

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Hi,

    Please do not get confused by the various replies.

    Keep it simple.

    What is the field that you have created at Item Table? If that field is only entry field, you would not get Lookup. 

    However, if the value in that particular field is being fetched from other table, you would get it lookup of that field. 

    For e.g. Please check the Base Unit of Measure field TableRelation Property. Data is getting fetched from other table and hence you would get the lookup of that field. 

    8547.1.PNG

  • snoppy Profile Picture
    snoppy 4,824 on at

    Thank you very much! This new filed will not fetched from the other table. So it doesn't work. After further testing, I realized it. Thank you all!

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
TAHER_El_Mehdi Profile Picture

TAHER_El_Mehdi 2

#1
sliderxb Profile Picture

sliderxb 2

#1
broberts Profile Picture

broberts 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans