[{"_1":2,"_67":-5,"_68":-5},"loaderData",{"_3":4,"_37":38,"_65":-5,"_66":-5},"root",{"_5":-5,"_6":-5,"_7":8,"_22":-5,"_23":24,"_25":26,"_29":30,"_35":36},"user","shoppingCartId","shoppingCart",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":14},"id","no-cart","count",0,"free",true,"updatedAt","2026-02-04T16:29:57.230Z","paymentGateway","STRIPE","cartItems",[],"loading","toast","locale","en","constants",{"_27":28},"paypalClientId","AX53Cwz8jR6rVVzzZiZNWWXl0dGagi-GZrjG-S3Ua14E5nrKMn7DxDQ730O4R8LusLPp49ALn6aRVaEy","publishers",{"_31":32,"_33":34},"companies",[],"universities",[],"needsLocaleCookieSync",false,"routes/_store+/_readers+/email_author.$slug/route",{"_39":40,"_64":-5},"book",{"_9":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51},"Z2lkOi8vbGVhbnB1Yi9TdG9yZTo6Qm9va1Byb2R1Y3QvNzU1NDI","title","MB-820 Exam Cram: Reports, Report Extensions and Queries","state","published","contactAuthorMethod","email","aboutText","

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)

","authors",[52],{"_9":53,"_54":55,"_5":56},"Z2lkOi8vbGVhbnB1Yi9TdG9yZTo6UHJvZHVjdEF1dGhvci84MDkxNw","name","Silviu Virlan",{"_57":58},"avatar",{"_59":60,"_61":62,"_63":14},"url","https://d39qdlcrvnra4b.cloudfront.net/avatars/1675007/medium/Headshot.jpg?1768316433","styleName","medium","exists","currentUser","routes/_store+/_layout","routes/_store+/_readers+/_layout","actionData","errors"]

Email the Author