Profile cover photo
Profile photo
AKILAN AKI
134 followers
134 followers
About
Posts

Post has attachment
Sample JavaScript to retrieve using Web API in Dynamics CRM 2016 / 365
function executeWebApiQuery(query, type) {     var result = null;     var clientURL = Xrm.Page.context.getClientUrl();     var req = new XMLHttpRequest()     req.open(type, encodeURI(clientURL + query), false);     req.setRequestHeader("Accept", "applicatio...
Add a comment...

Post has attachment
MS CRM - Fetchxml retrieve more than 5000 records C#
     string fetchtogetactivecustomer = @"<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false'>   <entity name='contact'>     <attribute name='fullname' />       <attribute name='contactid' />     <order attribute='fullname' d...
Add a comment...

Post has attachment
MS CRM 2011 - Enable button based on users security role - Custom rule using javascript
// JavaScript source code function VisibleButtonBasedOnUserRole() {     try     {         var CRMRole = UserHasRole("System Administrator");         if (CRMRole) {             return true;         } else {             return false;         }     }     catch...
Add a comment...

Post has attachment
Accessing WCF Service at WCF Client using Custom Binding created programmatically
                           EndpointAddress remoteAddress = new EndpointAddress(WebServiceURL);                 TestServiceClient serviceClient = new TestServiceClient(GetBinding(), remoteAddress);                 serviceClient.ClientCredentials.UserName.Use...
Add a comment...

Post has attachment
MS CRM 2011 - Send Email with attachment ( C# )
      private static void SendEmail(string fromUserEmailId, List<string> toUsersEmails, string attachmentfileLocation, IOrganizationService orgService)       {                  EntityReference fromUser=GetUserbyEmailId(fromUserEmailId,orgService);          ...
Add a comment...

Post has attachment

Post has attachment
MS Excel - Using Index Match instead of Vlookup
=INDEX ( Column I want a return value from , ( MATCH ( My Lookup Value , Column I want to Lookup against , Enter “0” ))  Example, =IFERROR(INDEX(Sheet5!I:I,MATCH('duplicated clean'!A3,Sheet5!A:A,0)),"") Reference: http://www.randomwok.com/excel/how-to-use-i...
Add a comment...

Post has attachment
SSRS - Show blank / Empty rows in Table
1.Insert a new rows in the table 2.Set the visibility using the following expression =IIF(CountRows() < 1 = 0, true, false) Note: Similarly we can show multiple empty rows. in my case ,i added 10 empty rows & set the row visibility using below expression =I...
Add a comment...

Post has attachment
SSRS - Forcing subreport Contains Empty data / no rows to Show
1.Add a dataset ("dataset2)" in sub report with following query SELECT ' ' AS DUMMY     2.Add a empty textbox with following expression =First(Fields!DUMMY.Value, "DataSet2")   Reference: https://coderwall.com/p/meqrng/forcing-a-ssrs-subreport-to-show
Add a comment...

Post has attachment
Wait while more posts are being loaded