Microsoft Dynamics GP is an SQL Server-based application. There are many times that using queries are useful. Organizing data for reports and updating data are two common uses of queries. This webinar will focus on selecting data for reporting. Following up on our April 2019 webinar, we'll walk through examples of SQL queries using SQL Server Management Studio and SQL Server Reporting Services Report Builder.
Upon completion of this program, participants will be able to:
- Explain how to use the Select Statement to query GP tables and views
- Describe how to use the Reporting Services Report Builder tool to query data
- Identify which tables, views and functions to use for queries