Posts

Showing posts from December, 2022

Pass Record Id Dynamically As Parameter to SSRS Report Using Fetch Xml

Image
As we know we can pass id dynamically in fetch Xml query by using parameter in SSRS report. In SSRS report our purpose to make report dynamic based on any condition. In condition whatever value is present we can make as parameter in report data. We will show you step to make parameter dynamic. You can follow the below link for basic of SSRS report like How to create and what all component is require. https://juniorcrmblog.blogspot.com/2022/02/ssrs-reports-for-dynamics-365-using.html Step1: Create a Data Source to make sure which type of data source type we use to perform the query expression. Just right click on the data source and provide the name, Embedded connection type and Connection String(In connection string provide the Dynamic CRM URL like "https://juniorcrm.crm9.dynamics.com").  If you don't know what is the means of crm9,crm8,crm7 etc. please see the below link. https://juniorcrmblog.blogspot.com/2022/02/what-does-crm1crm2-crm3crm4-mean-in.html Step2: Add the d

Why do we need to create configuration entity in dynamic CRM.

Image
Introduction : As we know we have different different types of entity in present in dynamic CRM. like that we can create a configuration entity. Creating configuration entity we can save lots of space on form and no need to create extra field of any of the entity. Benefit:  No need to create extra field and minimize the form heavy lifting data. Case 1: In my scenario if there is configuration entity which is containing the form of JSON data formats like below. in this we have different type of filed record like status Reason, Type Code and Reason Code but later we have again requirement to add another field record like Completion and another field record so we can easily add the field like below screenshot. But if we are using form to add filed then it would be very heavy lifting for form because we don't know when new requirement come and we need to add the filed in the form so that is way we have created a new entity and called name as configuration entity.. Note : In previous tr

How to make field only take 10 digit mobile number in dynamic CRM using JavaScript

Image
Scenario:  Phone number should be 10-digit number and no alpha value. if phone number more than 10 digit number and include any alpha value so field must be give the warning message. Screenshot:  Code : function onchangeofPhone(executionContext) {         "use strict";         //This function is used in Location form         var formContext = executionContext.getFormContext();         if (formContext.getAttribute("telephone1") != null && formContext.getAttribute("telephone1").getValue() != null) {             var phone = formContext.getAttribute("telephone1").getValue();             var match = phone.match(/[0-9]{10}/);             if (!match || phone.length != 10) {                 setFieldNotification("telephone1", "Please provide 10 digit Phone");             }             else {                 clearFieldNotification("telephone1");             }         } function setFieldNotification(controlName, message

JavaScript Code For Beginner In Dynamic CRM

Check if Object is null or undefine in dynamic DCRM using JavaScript.. checkIfObjectNullAndUndefine: function (obj){ "use strick", if ((obj ===undefine)|| (obj === null)) { return true; } return false; }; Check field has value  checkFieldHasValue(FormContext, fieldName){ //Do Logic here } checkFieldHasValue: function (formContext, fieldName)  {         "use strict";         return (checkFieldIsPresent(formContext, fieldName) && !checkIfObjectNullOrUndefined(formContext, formContext.getAttribute(fieldName).getValue())); };  checkFieldIsPresent: function (formContext, fieldName) {         "use strict";         return !checkIfNullOrUndefined(formContext, formContext.getAttribute(fieldName));     }; Note : Here checkIfNullOrUndefined call above function. Remove Curley bracket from GUID Formats like  : "{e117dg4b-9686-ed11-81cd-001dd806b77d}" toe117dg4b-9686-ed11-81cd-001dd806b77d.  var guidFormtes = formContext.getAttribute(fieldSchemaName).g