SQL Server Reporting Services (SSRS) 201 in Dynamics GP
October 27th, 2020 This half day online course begins at 1 PM Eastern Learn from SME's, Certified Trainers & Microsoft MVP's in live, instructor-led online courses
Have you been using SQL Server Reporting Services but want to do more with it? With this class, you will learn additional functionality to help you take your report writing to the next level. SSRS 101 taught you what SSRS is and how to build some basic reports. This class takes that basic knowledge and helps you add to it. This course is for GP users who want to write more complex reports and will focus on hands-on use of the tools in a virtual environment.
This class is an intermediate class on SQL Reporting Services with Dynamics GP. Its focus is on writing reports based on GP data. We will begin with a review of SSRS 101 fundamentals and move into intermediate concepts. We will create multiple report templates, build reports using templates, and utilize both Report Builder and Business Intelligence Development Studio. We will explore using more advanced queries to build datasets for reports. Additionally, we will use various functions available in SQL Server Reporting Services to add functionality to our reports.
Understand the difference between creating reports using Report Builder and Business Intelligence Development Studio
Create a Report Server project
Create a report using BIDS
Understand the benefits of and how to create report templates
Building reports based on report templates
Understand how to create reports with these features:
Explicit page breaks
Implementing fixed and dynamic columns and rows
Using the Switch, Lookup, LookupSet, MultiLookup, Join, and Split functions
Audience: Power-user, GP Support, IT Professional
Prerequisites: Understanding of Dynamics GP processes and terms, some exposure to SQL Server Management Studio and SQL concepts, some experience in report writing (e.g., Crystal Reports, Microsoft Access, etc.) is helpful but not required.
CPE Credits: By participating in this class you are eligible to earn up to 4 CPE credits which will be distributed automatically following class completion.
Senior Managing Consultant
Already registered and ready to join?
Please note, you will not be able to join until 2 minutes prior to the class date and time.