Tag: KTL Solutions

Getting Hyper about Hyperlinks

You can increase productivity and efficiency by using hyperlinks in your Excel documents. Hyperlinks are incredibly easy to setup and even easier to use. 

 The easiest method for inserting a hyperlink is to create a link to a website. Excel recognizes the syntax of ‘www.something.’ When you type a website into a cell, Excel will automatically create the link for you. Try typing a familiar website into a cell in Excel.
Read More »

CRM Online Reporting Using FetchXML

Reports are a way of presenting useful data to the users in an organized format. CRM reporting needs are often solved by using out-of-box CRM reports, Advanced Find, Dashboards and Charts, or the Report Wizard. But when a business demands a complex report involving calculations, grouping, detailed layouts, etc., then custom reports are needed. There are two types of reports in Microsoft Dynamics CRM:

Read More »

Best Practice for Building CRM Queries in an SSRS Custom Report

When writing a custom SSRS report for CRM, one of the greatest features is the ability to include pre-filtering in your reports.  By adding the CRMAF_ prefix to the alias assigned to the table you are querying, it will pass your selected CRM records as the context for your report. E.g.:

SELECT * FROM FilteredAccount AS CRMAF_Account

When writing a custom SSRS report for CRM, one of the greatest features is the ability to include pre-filtering in your reports.  By adding the CRMAF_ prefix to the alias assigned to the table you are querying, it will pass your selected CRM records as the context for your report. E.g.:

SELECT * FROM FilteredAccount AS CRMAF_Account

When writing a custom SSRS report for CRM, one of the greatest features is the ability to include pre-filtering in your reports.  By adding the CRMAF_ prefix to the alias assigned to the table you are querying, it will pass your selected CRM records as the context for your report. E.g.:

SELECT * FROM FilteredAccount AS CRMAF_Account

When writing a custom SSRS report for CRM, one of the greatest features is the ability to include pre-filtering in your reports.  By adding the CRMAF_ prefix to the alias assigned to the table you are querying, it will pass your selected CRM records as the context for your report. E.g.:

SELECT * FROM FilteredAccount AS CRMAF_Account

When writing a custom SSRS report for CRM, one of the greatest features is the ability to include pre-filtering in your reports.  By adding the CRMAF_ prefix to the alias assigned to the table you are querying, it will pass your selected CRM records as the context for your report. E.g.:

SELECT * FROM FilteredAccount AS CRMAF_Account

Read More »

Using MS CRM “IPluginExecutionContext” to Tackle Business Needs: A 3 Part Series

The “IPluginExecutionContext” contains a property called “MessageName.” This is the name of the message that was called to perform the action. Here is a link to a list of messages: https://msdn.microsoft.com/en-us/library/gg309482.aspx .   I couldn’t find my original source for this, so you can assume that each message name is just the class name listed without the request at the end. The one we are interested in is the “ConvertQuotetoSalesOrderRequest” or the “ConvertQuoteToSalesOrder” message. This is what is called when you click the “Create Order” button and can be called through the API as well. So to figure out if that is what is creating our sales order we would simply need to traverse the parent context list and check to see if the “MessageName” property equals “ConvertQuoteToSalesOrder”. Here is a code snippet to do that. 

Read More »

Best Practices in Properly Preparing Your Company for an Upgrade

At KTL Solutions we have worked with a lot of upgrade projects involving Microsoft business products, including Dynamics GP, CRM, SharePoint, Exchange, etc. In today’s post we will discuss the preparation you can do as a system administrator to prepare for an upgrade of Dynamics CRM. An upgrade project starts early on when we first investigate/review the existing state of the CRM environment. In most cases, we perform an upgrade by migrating to a new instance of SQL server. In case of multiple version upgrades, we do a migration, and then do an in-place upgrade.

Read More »

Using MS CRM “IPluginExecutionContext” to Tackle Business Needs: A 3 Part Series

STOPPING A SALES ORDER FROM BEING CREATED

Stopping an operation using a plugin is a simple process. All you need to do is throw an exception, but its best to not just throw any exception. CRM provides the “InvalidPluginExectionException” that allows you to pass in a message that will get displayed to the user. Using that, we can alert the user that the action they took is not allowed and guide them in the direction of the correct way to create an order.

Read More »