Company: Pluralsight Author: Alexandra Santiago Full Title: Building Interactive SSRS Reports Year: 2019 Language: English Genre: Educational Skill Level: Intermediate Price: - - Files: MP4 (+ Code Files, Slides .PDF, Subtitles .SRT) Time: 03:28:01 Video: AVC, 1280 x 720 (1.778) at 30.000 fps, 400 kbps Audio: AAC at 96 Kbps, 2 channels, 48.0 KHz In this course, you'll learn how to make use of SSRS features to create interactive reports. The reports will become dynamic for users by using functionalities such as drilldown, drill through, interactive sorting, jump actions, and document maps. At the core of SSRS report development is a thorough knowledge of interactive reporting. In this course, Building Interactive SSRS Reports, you’ll learn how to create visually appealing, dynamic, interactive, and easily navigated reports. First, you’ll learn the basics of visibility conditions and interactive sorting. Next, you’ll explore filtering and use of parameters. Finally, you’ll discover how to link reports by using jump actions and create drilldown and drill through reports. When you’re finished with this course, you’ll have a foundational knowledge of building interactive SSRS reports that will help you as you move forward to designing and building reports. Software required: Microsoft SQL Server Reporting Services 2017 (SQL Server Data Tools 2017), Microsoft SQL Server Management Studio 17 Lessons: 1. Course Overview 01. Course Overview 2. Getting Started 02. Course Introduction 03. Module Overview 04. Demo: Viewing Interactive Reports 3. Implementing Fixed Headers 05. Module Overview 06. Implementing Fixed Headers on a Matrix 4. Implementing Interactive Sorting 07. Module Overview, Sorting Suppliers and Stock Items 08. Implementing Interactive Sorting on a Matrix 5. Implementing Show/Hide Property 09. The Show/Hide Property 10. Using the IIF Function 6. Implementing Filters 11. Filter Equations 12. Static Filtering vs. Dynamic Filtering 13. Demo: Filtering on Different Levels of Data 7. Creating Dynamic Reports in SSRS Using Parameters 14. Overview, Definitions, and Demo: Implementing Dataset Parameter 15. Demo: Stored Procedures and Query Parameters 8. Implementing Drilldown 16. Module Overview 17. Demo: Implementing Drilldown 9. Implementing Drill Through 18. Module Overview and Demo: Implementing Drill Through 19. Demo: Implementing Drill Through from Charts 10. Implementing Actions 20. Module Overview 21. Demo: Implementing Actions 22. Module Summary 11. Implementing a Document Map 23. Module Overview 24. Demo: Implementing a Document Map 25. Module Summary 12. Formatting SSRS Placeholders Using Embedded HTML 26. Module Overview 27. Demo: Formatting SSRS Placeholders 28. Module Summary Our members see more. Join us! ------------- Our members see more. Join us!