Format: Academy Course
Preparation: Please bring a Windows PC to class for the Academy’s hands-on training environment from Visilearn called vConnect.
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 SQL Data Tools
â€¢Create a report using SQL Data Tools
â€¢Create reports using Report Builder
Understand how to create these types of reports:
â€¢Record Lists - Display information from one or more tables
â€¢Mailing Labels - Create mailing labels of various sizes
â€¢Graphical reports - Display charts, data bars, spark lines, and indicators
â€¢Operational Reports using Parameters - Report that utilizes multiple different types of parameters
â€¢Pivot Table-Style Reports - Aggregate data
With these reports, you will use this functionality:
â€¢Explicit page breaks
â€¢Data bars, indicators, and spark lines
â€¢Using the Switch function
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.
Training Materials: Will be supplied by the instructor as appropriate.
Delivery Method: Group Live
I have 10 years experience in accounting for various industries, and I have 5 years experience in ERP software development . Today, my role as a consultant for BKD Technologies includes all phases of software implementations across the Microsoft Dynamics platforms, specifically Dynamics GP and Dynamics 365. From planning, implementation, training, and support, my experience with different industries allows for a broad understanding of business systems, and the needs of our clients. I also develop Dynamics GP addins, and currently work with our Dynamics 365 teams for architecting and developing custom solutions for our clients that need a cloud-based solution. I enjoy bridging the communication gaps between accounting and technologies.
Tuesday, October 10
8:00 AM – 5:00 PM