MB-820 Exam Cram: Reports, Report Extensions and Queries
Master data presentation and analysis in Business Central! This comprehensive guide covers everything from report objects and layouts (RDLC, Word, Excel) to report extensions for customization without modifying base code. Learn about queries for optimized data retrieval, processing-only reports, request pages, and the report substitution pattern. Dive deep into real-world examples from the Base Application with practical exercises. Whether you're preparing for MB-820 certification or building professional reporting solutions, this is your definitive reference for Business Central reporting.
Minimum price
$15.00
$20.00
You pay
$20.00Author earns
$16.00About
About the Book
MB-820 Exam Cram: Reports, Report Extensions, and Queries in Business Central
A Complete Guide for Business Central Certification
Master data presentation and analysis in Business Central! This comprehensive guide covers everything you need to know about creating professional reports, extending existing reports without modifying base code, and building efficient queries for data retrieval.
What You'll Learn:
- Complete report object architecture with datasets, request pages, and triggers
- Understanding the three layout types: RDLC, Word, and Excel
- Creating processing-only reports for batch operations
- Extending reports with the reportextension object (BC 2021 wave 1+)
- Adding columns, data items, triggers, and new layouts to existing reports
- Report substitution patterns for complete report replacement
- Building queries for server-side data aggregation
- Using queries in reports for optimized performance
- Publishing queries as OData web services
- MB-820 exam-focused tips and practice questions
Who This Book Is For:
- MB-820 certification candidates
- Business Central AL developers
- Partners building reporting solutions
- Consultants customizing standard reports
- Technical professionals extending Business Central
What's Inside:
- 30+ pages of detailed content
- 7 hands-on exercises with complete solutions
- 20 exam-style practice questions with detailed answers
- Real-world report and query examples from the Base Application
- Report extension patterns and best practices
- Code samples from actual implementations
- Complete troubleshooting reference
- MB-820 exam preparation tips
Key Topics Covered:
- Report Object Architecture (dataset, request page, triggers, layouts)
- Layout Types (RDLC for precision, Word for documents, Excel for analysis)
- Report Properties (UsageCategory, ProcessingOnly, DataAccessIntent)
- Data Items and Columns (DataItemLink, RequestFilterFields, IncludeCaption)
- Report Triggers (OnPreReport, OnAfterGetRecord, OnPostReport)
- Rendering Section (multiple layouts per report)
- Processing-Only Reports (batch processing, data updates)
- Report Extensions (add columns, data items, triggers, layouts)
- Extension Triggers (OnBeforeAfterGetRecord, OnAfterAfterGetRecord)
- Report Substitution (OnAfterSubstituteReport event)
- Query Objects (server-side aggregation, SQL optimization)
- Query Properties (TopNumberOfRows, OrderBy, SqlJoinType)
- Aggregation Methods (Sum, Count, Average, Min, Max)
- Query-Based Report Pattern (using queries in reports)
- OData Web Services (publishing queries as APIs)
Based on Microsoft Learn Documentation, Base Application Examples, and Real-World Experience
Companion Resources:
- YouTube video walkthrough: Reports - https://youtu.be/z9t3cuCxD8A
- YouTube video walkthrough: Report Extensions - https://youtu.be/5Q8-jGCGYH4
- YouTube video walkthrough: Reports and Queries - https://youtu.be/t9PWMI1qkfM
- Sample code: https://github.com/SilviuVirlan/Episode-14-An-intro-to-AL-reports
- Sample code: https://github.com/SilviuVirlan/Episode16
- Sample code: https://github.com/SilviuVirlan/Episode-17-Report-Extension-sample
- Official Microsoft Learn documentation links
Perfect for:
- Passing the MB-820 exam with confidence
- Creating your first AL report
- Extending standard Business Central reports
- Building efficient query-based solutions
- Understanding report architecture deeply
- Reference guide during development
Author: Based on Microsoft Dynamics 365 Business Central official documentation, Base Application source code analysis, and MB-820 exam requirements.
Get ready to master Business Central reporting and pass your MB-820 exam!
Part of the MB-820 Exam Cram Series:
- Install and Upgrade Codeunits Guide
- Business Central Admin and Automation API Guide
- Performance Toolkit Guide
- Cloud Migration Tool Guide
- Create New Companies Guide
- Outlook Integration Guide
- Teams Integration Guide
- Tables and Table Extensions Guide
- Pages and Page Extensions Guide
- Reports, Report Extensions, and Queries Guide (this book)
Bundle
Bundles that include this book
MB 820 Exam Cram: Complete Guide
11 Books
- Pricing
$125.00
Minimum priceBought separately$189.50Suggested price$150.00
Author
About the Author
Silviu Virlan is a Microsoft MVP for Business Applications (awarded multiple times, including a second recognition in recent years), MCP (Microsoft Certified Professional), and a highly respected Dynamics 365 Business Central expert.
With over 12 years of hands-on experience in Dynamics NAV and Business Central, Silviu specializes in AL development, extensions, integrations, performance optimization, and modern AI-driven analytics. He served as a Developer Lead or Technical Architect in Dynamics 365 Business Central development teams for various Microsoft Partners in USA and Canada.
Since 2017, Silviu has been a dedicated contributor to the global Business Central community. He shares practical knowledge and deep technical insights through:
- His popular blog at www.svirlan.com, featuring tutorials, release wave overviews, and best practices.
- The Business Central Musings YouTube channel (@BusinessCentralMusings), home to well-received educational series such as: - "Let's pass MB-820" – a comprehensive certification prep playlist - "What's new in Business Central" – covering 2023, 2024, 2025, and beyond release waves
In 2024, Silviu authored the book "Beyond the Ledgers: Cutting-edge Data Insights with Business Central and AI", a practical guide that helps users and developers unlock powerful analytics, automation, and AI capabilities within Business Central.
A sought-after speaker, you can often find Silviu presenting at major technical conferences including Directions, DynamicsCon, and Community Summit, where he delivers sessions on cutting-edge Business Central topics, from AL language features to advanced integrations and user experience enhancements.
Through his content, speaking engagements, and community leadership, Silviu continues to empower developers, consultants, and partners to build better solutions in the ever-evolving world of Dynamics 365 Business Central.
Contents
Table of Contents
The Leanpub 60 Day 100% Happiness Guarantee
Within 60 days of purchase you can get a 100% refund on any Leanpub purchase, in two clicks.
Now, this is technically risky for us, since you'll have the book or course files either way. But we're so confident in our products and services, and in our authors and readers, that we're happy to offer a full money back guarantee for everything we sell.
You can only find out how good something is by trying it, and because of our 100% money back guarantee there's literally no risk to do so!
So, there's no reason not to click the Add to Cart button, is there?
See full terms...
Earn $8 on a $10 Purchase, and $16 on a $20 Purchase
We pay 80% royalties on purchases of $7.99 or more, and 80% royalties minus a 50 cent flat fee on purchases between $0.99 and $7.98. You earn $8 on a $10 sale, and $16 on a $20 sale. So, if we sell 5000 non-refunded copies of your book for $20, you'll earn $80,000.
(Yes, some authors have already earned much more than that on Leanpub.)
In fact, authors have earned over $14 million writing, publishing and selling on Leanpub.
Learn more about writing on Leanpub
Free Updates. DRM Free.
If you buy a Leanpub book, you get free updates for as long as the author updates the book! Many authors use Leanpub to publish their books in-progress, while they are writing them. All readers get free updates, regardless of when they bought the book or how much they paid (including free).
Most Leanpub books are available in PDF (for computers) and EPUB (for phones, tablets and Kindle). The formats that a book includes are shown at the top right corner of this page.
Finally, Leanpub books don't have any DRM copy-protection nonsense, so you can easily read them on any supported device.
Learn more about Leanpub's ebook formats and where to read them
Write and Publish on Leanpub
You can use Leanpub to easily write, publish and sell in-progress and completed ebooks and online courses!
Leanpub is a powerful platform for serious authors, combining a simple, elegant writing and publishing workflow with a store focused on selling in-progress ebooks.
Leanpub is a magical typewriter for authors: just write in plain text, and to publish your ebook, just click a button. (Or, if you are producing your ebook your own way, you can even upload your own PDF and/or EPUB files and then publish with one click!) It really is that easy.