In Microsoft Dynamics NAV 2017, Reports and Queries are two ways to extract and output data for the purpose of presentation to a user (Reports can also modify data). Each of these objects use tools and processes that are NAV based for the data extraction (XMLports, which can also extract and modify data, will be covered in Chapter 8, Advanced NAV Development Tools. In this chapter, we will focus on understanding the strengths of each of these tools and when and how they might be used. We will cover the NAV side of both Queries and Reports in detail to describe how to obtain the data we need to present to our users. We will cover output formatting and consumption of that data in less detail. There are currently no wizards available for either Query building or Report building, therefore all the work must be done step by step using programming tools and our skills as designer/developers. The following are the topics we will cover in this chapter:

• Queries and Reports
• Report Components - overview
• Report Data Flow
• Report Components - detail
• Creating and modifying Reports