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

Calling a Dynamics NAV OData web service

As you already know, you can publish page and query objects and OData web services in Dynamics NAV. Reporting Services reports can also use OData web services as data sources.

Note

In Chapter 9, Power BI, there are examples of how you can publish a query or page as a web service.

I will create the same report again, a list of customers, but this time based on an OData web service. I will first create a new Page 90000 Customers, in which I will add the field from the Customer table that I want to use in my report. Then, I will publish this page as a web service:

Calling a Dynamics NAV OData web service

Then, I will create a new report in SSDT. I will ...

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