Donghai

👋 Welcome to my corner of the web. Here, I document the hurdles I hit in projects, the things that spark my curiosity, and the traces of where I've been — books, trips, and the people along the way.

Featured

• D365 - Commonly Used SQL

  17 Feb, 2025

  A guide on commonly used SQL queries in Dynamics 365 for querying views, reports, file sizes, security roles, and user assignments.

• D365 - Add Colors to OptionSet Fields

  14 Nov, 2024

  Learn how to add color labels to OptionSet fields in Dynamics 365 to enhance visibility and improve user experience. This guide covers both global and local configurations, including steps for views, forms, subgrids, and quick create forms.

• D365 - Exporting Reports as PDF Introduction

  17 Oct, 2024

  This blog post provides a detailed guide on exporting reports as PDF in Dynamics 365. It discusses a real-world scenario involving a complex SSRS report for quotations and outlines the implementation steps to create a custom export button. The article covers the rationale behind choosing a custom button approach over standard features, along with practical instructions for adding JavaScript and binding it to the button. Ideal for developers and users looking to enhance their reporting capabilities in Dynamics 365.

Recent Posts

• D365 - Set User Default Time Zone

  28 Aug, 2025

  Learn how to set the default time zone for users in Dynamics 365 using the User Settings Utility in XrmToolBox. This guide covers installation, user information loading, and time zone updating, along with SQL queries to retrieve current user time zone settings.

• D365 - XrmToolBox Loading Errors

  6 Jun, 2025

  Discover solutions to common loading errors in XrmToolBox, including issues with NuGet packages. This comprehensive guide walks you through troubleshooting steps, including how to locate and manage the plugin installation directory. Learn how to efficiently resolve plugin-related problems to ensure smooth operation of your XrmToolBox environment.

• D365 - License Expiration Check

  21 Apr, 2025

  A quick guide on how to check license renewal or expiration dates for Dynamics 365 environments in both Global and 21Vianet (China) Microsoft 365 admin centers.

• D365 - Follow-up Actions After Mailbox Password Expiration

  26 Mar, 2025

  Troubleshooting guide for resolving email notifications not being sent in Dynamics 365 due to an expired mailbox password, with detailed steps for reviewing Email Logs and restoring normal email delivery.

• D365 - Storing Multi-Select Display Names in Text Fields

  14 Mar, 2025

  This blog post explores how to store display names of multi-select fields in text fields within Dynamics 365. It covers common challenges faced in SSRS paginated reports and provides step-by-step solutions using plugins and third-party workflow tools like Dynamics-365-Workflow-Tools. Learn effective strategies to enhance your reporting capabilities by managing multi-select options efficiently.