O'Reilly logo

Microsoft Dynamics NAV 2015 Professional Reporting by Steven Renders

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Filtering and sorting

Filtering and sorting are important concepts when running a report and, in many cases, are offered to the users as options in the request page.

How can I implement filters?

For every data item in your dataset there will be a separate tab in the request page allowing the users to apply filters on any of the fields of the tables. You can use the following properties to manage this:

  • ReqFilterFields: The fields you put in here are the default fields that will be shown for this data item in the request page.
  • DataItemTableView: If you select a key in this property then the data item disappears from the request page, unless you have selected RegFilterFields. The user will not be able to select a sorting order for this data item.
  • ReqFilterHeading ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required