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

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Hide/Dissable "Sh...
Microsoft Dynamics NAV (Archived)

Hide/Dissable "Show Results" Filter Option on Sales Report

(0) ShareShare
ReportReport
Posted on by Community Member

Hi

I have created a new report and made some amendments based on (Customer - Top 10 List Report 111) and wandered if it was possible to hide or dissable the "Show Results" filter when you run the report but keep the "Limit Totals" section of the filtering.

If not, is it possible to not be able to choose "No" (Customer No.) in the look up part of the filter? 

The reason I ask is that I have created a role for our external sales engineers only to see customers relating to them based on the sales person code set on the customer cards which works great however if the sales engineer runs his top 10 list and chooses No. in his Show results fitler then when he drills into the next section to choose the customer no./s  he can see all customers not just his own based in his area.

Plesae advise.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,249 Super User 2025 Season 2 on at

    From the design select the customer dataitem and in the properties remove the values from the ReqFilterFields

  • Community Member Profile Picture
    Community Member on at

    Great I see that when remove these so that it is "undefined" this then does not allow to see any filters when you run the report however I want to keep the "Limit Totals" part of the filtering.  Is this possible?

    Please advise.

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,249 Super User 2025 Season 2 on at

    No,i don't think that is possible. You can add other fields to ReqFilterFields other than No. but the user will always have the ability to apply the filter by using Add Filter. If you add any field to ReqFilterFields it will give you the Limit Totals option but as said the user can always choose other fields by using Add Filter.

  • Community Member Profile Picture
    Community Member on at

    Oh thats a shame.

    Can I set defualt filter options which cannot be changed?

    Please advise.

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,249 Super User 2025 Season 2 on at

    Yes you can choose the fields from the ReqFilterFields property.

  • Community Member Profile Picture
    Community Member on at

    I thought so but when for e.g I choose Salesperson Code and what to set the default to the salesperson how do i enter this.  If I click on the build (...) next to reqfilterfields and choose Salesperson code how do I set the default?

    When I try and enter Salesperson Code="NG" the systems states I cannot enter this in FieldNo.?

    Please advise

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,249 Super User 2025 Season 2 on at

    Those are two different things, if you need default filter fields then you use ReqFilterFields but if you want filter a field to a specific value then you need to choose that on DataItemtableView property choose the Table Filter where you can add field and default value using CONST

  • Community Member Profile Picture
    Community Member on at

    Fantastic - its the second option I was trying to get too - sorry I don't always explain very well.

    Many thanks thats worked a treat.

  • Community Member Profile Picture
    Community Member on at

    Hi

    Sorry I have another quick question now if you can help?

    If I choose the Date Filter as an option to set a specific date range using the DataItemtableView way and choosing FILTER instead of CONST is there a way I can set the report to recognise using i.e Today-365 and run as that instead of inputting the actual date from and date to as a range?  This would be helpful if as this would then change daily and then I won't have to keep altering the date ranges.

    Please advise.

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,249 Super User 2025 Season 2 on at

    No, you cannot do that using DataItemTableView but you can achieve your requirement by adding the code in OnPreReport trigger as shown below

    Customer.SETRANGE("Date Filter",TODAY,CALCDATE('<1Y>',TODAY));

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

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
HoangNam Profile Picture

HoangNam 7

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans