[TIP] Resolving Connection Issues in SSRS for Dynamics 365

 

[TIP] Resolving Connection Issues in SSRS for Dynamics 365

When working with SQL Server Reporting Services (SSRS) in Dynamics 365, you might come across a peculiar issue where the metadata doesn't appear as expected, or the CRM Login pop-up window fails to display the list of available organizations, even when the option "Display list of available organizations" is checked. The root cause could be the credential settings in the data source of your SSRS project.

How to Install SSRS template of Visual Studio for Dynamics 365/CRM

 How to Install SSRS template of Visual Studio for Dynamics 365/CRM

This article will introduce how to install the SSRS template of Visual studio before you start to create your first SSRS report for Dynamics 365/CRM/CE. 

[TIP] Converting Date/Time Parameters to Text for FetchXML Queries in SSRS Reports

[TIP] Converting Date/Time Parameters to Text for FetchXML Queries in SSRS Reports

Introduction: When working with SQL Server Reporting Services (SSRS) in conjunction with FetchXML queries, you might encounter a scenario where date/time parameters cannot be used directly. This article outlines a practical solution to convert date/time parameters to text type, enabling their use in FetchXML queries within SSRS reports.

Setting Date-Only Fields in Dynamics 365 with Local Time Using N52 Formulas

 

Setting Date-Only Fields in Dynamics 365 with Local Time Using N52 Formulas

Introduction

When working with date-only fields in Dynamics 365, displaying the correct local time can be a challenge. By default, Dynamics 365 stores DateTime fields in Coordinated Universal Time (UTC). This article explains how to set a date-only field to display the local time using N52 formulas.

Setting Lookup Fields in Dynamics 365 Using the N52 SetLookup Function

 

Setting Lookup Fields in Dynamics 365 Using the N52 SetLookup Function

Introduction

In Dynamics 365, Lookup fields often need to be set programmatically, based on certain conditions or actions. One common requirement is to set a Lookup field to a specific entity based on its GUID. The N52 formula engine provides the SetLookup function to meet this need efficiently. This article will walk you through how to use SetLookup to set Lookup fields in Dynamics 365.

[TIP] How to Get Lookup Field Name and Option Set Field Selected Option's Name in N52 Formulas

 

How to Get Lookup Field Name and Option Set Field Selected Option's Name in N52 Formulas

Introduction

When working with N52 formulas in Dynamics 365, you might need to display the name referenced by a Lookup field or the name of a selected option from an Option Set field. This article aims to guide you through these tasks using N52 formulas.

Understanding Intersect Entities and Bridge Entities in Dynamics 365

 

Understanding Intersect Entities and Bridge Entities in Dynamics 365

Introduction

When working with Dynamics 365, the term 'Intersect Entity' might come up when dealing with N:N relationships between entities. This article aims to explain what an Intersect Entity is, how to find its schema name, and how to query it using tools like XrmToolbox.

[TIP] How to Modify the Primary Navigation in a Dynamics 365 Portal

 

How to Modify the Primary Navigation in a Dynamics 365 Portal

Introduction

This updated article focuses on modifying the "Primary Navigation" in a Dynamics 365 Portal. This is an out-of-the-box Web Link Set that controls the main navigation menu. You will learn how to update existing links or add new Child Links to customize your portal's navigation.

[TIP] Enabling Column Sorting on Related Tables in Power Apps Portals

Enabling Column Sorting on Related Tables in Power Apps Portals

Introduction: Power Apps portals offer remarkable flexibility in displaying and managing data. However, sorting columns from related tables in a list isn't straightforward. This article introduces a solution to enable this functionality.

Enhancing Search Functionality in Power Apps Portals: A Dive into FetchXML

Enhancing Search Functionality in Power Apps Portals: A Dive into FetchXML

Introduction

Power Apps portals offer a robust platform for building interactive web applications. One of its most notable features is the ability to create custom search filters using FetchXML. In this article, we'll explore how to use FetchXML for search filters, leverage JavaScript for UI adjustments, and examine the behavior of the "like" operator in FetchXML.

[TIP] Alerting Users When a Subgrid in Dynamics 365 Is Empty

 

Alerting Users When a Subgrid in Dynamics 365 Is Empty

Introduction

Dynamics 365 and Power Apps offer extensive customization options, one of which is the ability to use subgrids to display related records. While subgrids are helpful, there are scenarios where you might need to prompt the user with an alert if the subgrid is empty. In this article, we will discuss how to achieve this functionality using JavaScript and jQuery.

[TIP] Changing Element Height in Web Development - A Case Study with Quick View Forms in Dynamics 365

 

Changing Element Height in Web Development - A Case Study with Quick View Forms in Dynamics 365

Introduction

Changing the height of HTML elements is a common requirement in web development. This can often be achieved using CSS, but sometimes it requires a little more effort—particularly when dealing with iframes or other embedded content. In this article, we'll examine a specific case study that deals with adjusting the height of a Quick View form in Dynamics 365, a Microsoft product commonly used for CRM.

[TIP] Setting Default Values for Option Sets (Choice) in Dynamics 365 Using JavaScript

 

Setting Default Values for Option Sets (Choice) in Dynamics 365 Using JavaScript

Option Sets, also known as Choice fields in the latest version of Dataverse, are commonly used in Dynamics 365 to allow users to select from a pre-defined list of options. In some instances, you may want to set a default value for an Option Set (Choice) when a form is loaded. This can be achieved using JavaScript. Below are examples for both single-select and multi-select Option Sets (Choices).

How to Dynamically Hide Buttons in Power Apps Portal Using JavaScript and MutationObserver

 

How to Dynamically Hide Buttons in Power Apps Portal Using JavaScript and MutationObserver

Introduction

Creating a dynamic user interface is a critical aspect of application development in Power Apps Portal. One common use case involves conditionally showing or hiding UI elements like buttons based on certain criteria. This article will guide you through the steps to dynamically hide a "Create New" button in a subgrid when certain conditions are met, using JavaScript and the MutationObserver API.

Understanding Primary Key, Alternate Keys, and Primary Column in Dynamics 365

 

Understanding Primary Key, Alternate Keys, and Primary Column in Dynamics 365

Dynamics 365 offers various ways to uniquely identify and display records, which are important for data integrity, performance, and user experience. In this article, we'll explore the differences between Primary Key, Alternate Keys, and Primary Column, along with examples for each.

Utilizing JavaScript in Dynamics 365 Views for Column Customization

 

Utilizing JavaScript in Dynamics 365 Views for Column Customization

JavaScript can be employed in Dynamics 365 to enhance the presentation and functionality of columns in entity views. By using a Web Resource and specifying a JavaScript function, you can achieve various types of custom formatting and actions.

Dynamics 365 OOB Command Actions: A Detailed Exploration

 

Dynamics 365 OOB Command Actions: A Detailed Exploration

Introduction

Out-of-the-Box (OOB) Command Actions in Microsoft Dynamics 365 offer a range of functionalities designed to facilitate various business processes. In this article, we delve into some of the key OOB Command Actions, providing detailed descriptions, typical usages, and practical examples for each.


Comprehensive List of OOB Command Actions

1. AddToQueue

Description:
Moves an entity record into a queue.

Usage:
Often used in customer service scenarios for triaging and categorizing incoming cases.

Examples:

  • Moving high-priority customer service cases into a special queue for rapid resolution.

2. AddUserToRecordTeam

Description:
Adds a user to the access team of a specific record.

Usage:
Primarily used for facilitating collaboration on specific records.

Examples:

  • Adding a sales executive to an opportunity record for closer collaboration.

3. ApplyRoutingRule

Description:
Applies a routing rule to an entity record.

Usage:
Typically used in customer service settings to assign cases to specific queues based on attributes like priority, type, or service level.

Examples:

  • Routing cases related to a specific product line to the product team's queue.

4. CalculateActualValue

Description:
Calculates the actual value of an entity record, typically used for financial records like Opportunities.

Usage:
Used to re-calculate the actual financial value of an entity based on various criteria.

Examples:

  • Re-calculating an opportunity's value after adding additional line items or applying discounts.

5. CloseOpportunity

Description:
Changes the status of an Opportunity to "Won" or "Lost."

Usage:
Used in sales pipelines to formally close out opportunities.

Examples:

  • Marking an opportunity as "Won" after receiving a signed contract from the customer.

6. Fulfill

Description:
Completes a Sales Order, transitioning it to a "Fulfilled" status.

Usage:
Used in order processing and management.

Examples:

  • Changing the status of a sales order to "Fulfilled" after confirming shipment of the products.

7. GetQuoteProductFromOpportunity

Description:
Generates Quote Products based on an existing Opportunity.

Usage:
Used in the sales process to convert opportunities into quotes.

Examples:

  • Auto-generating a quote with all the products and services listed in an opportunity.

8. GetSalesOrderProductFromOpportunity

Description:
Generates Sales Order Products from an Opportunity.

Usage:
Often used to automate the transition from a closed-won opportunity to the creation of a sales order.

Examples:

  • Creating a sales order with all the line items listed in a closed-won opportunity.

9. LockInvoicePricing

Description:
Locks the pricing on an Invoice, making it uneditable.

Usage:
Used for financial compliance and to prevent unauthorized changes.

Examples:

  • Locking the pricing on an invoice once it has been approved and sent to the customer.

10. LockSalesOrderPricing

Description:
Locks the pricing on a Sales Order.

Usage:
Used to ensure pricing consistency and compliance after receiving customer approval.

Examples:

  • Locking pricing on a sales order after contractual agreement.

11. QualifyLead

Description:
Converts a Lead into an Opportunity, Contact, and/or Account.

Usage:
Used in sales and marketing to move a lead to the next stage of the customer journey.

Examples:

  • Converting a lead to an opportunity after they have shown a strong interest in a product or service during a discovery call.

12. RemoveUserFromRecordTeam

Description:
Removes a user from the access team of a specific record.

Usage:
Used to restrict access to records when necessary.

Examples:

  • Removing a user from an opportunity record when they move to a different department or leave the company.

13. ResolveIncident

Description:
Closes an Incident (or Case) record as "Resolved."

Usage:
Used in customer service workflows to close cases that have been satisfactorily resolved.

Examples:

  • Marking a customer support case as "Resolved" after successfully troubleshooting an issue.

14. ResolveQuote

Description:
Changes the status of a Quote to "Accepted" or "Declined."

Usage:
Used to formalize the outcome of a quoting process.

Examples:

  • Changing a quote status to "Accepted" after receiving customer approval.

15. Revise

Description:
Reverts a closed Quote back to an "Active" or editable state.

Usage:
Used to make changes to quotes that have already been closed.

Examples:

  • Re-opening a quote to add additional line items before re-submitting to the customer for approval.

16. SetWordTemplate

Description:
Applies a pre-defined Word template to an entity record to generate a document.

Usage:
Used to automate document creation in various business processes.

Examples:

  • Generating a contract document by applying a Word template to an Account entity.

Conclusion

Understanding and effectively using OOB Command Actions in Dynamics 365 can significantly streamline your business processes. These actions are integral components that can be invoked through workflows, custom code, or Power Automate flows, enabling greater automation and efficiency.