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,
April 6, 2016
Tag: Dynamics CRM
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
April 4, 2016
Dynamics CRM: You’re Only as Good as Your Data
Microsoft Dynamics Customer Relationship Management (CRM) is a fantastic tool for managing customers, accounts, cases, opportunity, sales people, etc. The possibilities with CRM are endless, which is why we often refer to it as xRM (the x can be anything you want it to be). As a CRM implementation, support, and development partner we often get questions from customer starting out with, “Can CRM do (insert request here)?” And the answer is usually, “Sure it can, but the question really is ‘Do you have the data to support a function like that’?”
March 9, 2016
Best Practice to Migrate Data into a New Dynamics CRM System
I often do CRM demos using the CRM trial for a couple of reasons. One, the trial only takes a minute to spin up, and secondly, each company I demo I try to tailor the presentation to their company. I find it easier to create a new environment than to demo and clean up a permanent demo environment.
February 24, 2016
2016 – What to Watch for as the Cloud Impacts Your Technology Partner’s Value
This is going to be about how the cloud is automating much of what IT did, (networks, maintaining emails, managed services) and how your technology partner will be giving you much higher value services instead.
Remember when you owned your own servers, connected your users via a network software and had some IT staff (or some outside IT firm) tell you when something was wrong, something needed to be updated or something was down?
January 18, 2016
How to increase profits and sales using CRM
Many times business executives get caught up in the details and miss the big picture. How do I increase sales, profits, and productivity? The answer might be right on your computer. Using Dynamics CRM, many options are available to easily and quickly increase your company's bottom line. Catching the attention of the Executive or Business owners in how to achieve better sales and profits and make more money is sometimes easier said then done. CRM is a company wide tool using technology to support a business strategy to improve, analyze and automate company sales, customer services, and marketing by combining them to improve the sales and profits of the company.
December 4, 2015
Being a Consultant at KTL and Our Annual User Conference.
In this blog, I wanted to provide a little insight into what it is like to be a Consultant at KTL Solutions and shed a little light on what our user conference is all about from a consulting perspective. I have been working at KTL Solutions as a Senior Business Consultant for a little over three years. In this capacity I have been implementing and supporting Microsoft Dynamics GP, Microsoft Dynamics CRM, and PaperSave along with many third party add-ons. Prior to working at KTL Solutions, I was also implementing and supporting ERP systems for about 20 years.
June 2, 2015
Make the Most of Your CRM System; Engage Your Staff to Engage Your Customers
We are not talking about the obvious such as how much of your budget to spend or about technical considerations, we are talking about what questions to ask and what decisions to make before searching for the Customer Relationship Management system that best suits your organization.
May 20, 2015
Marriage Counseling between Sales and Marketing
I was extremely fortunate to have KTL send me down to Atlanta, Georgia for one of Microsoft’s largest conferences, Convergence. Here I was able to really understand concepts involving both marketing and sales that pertained to us as partners using the solutions we not only implement and sell, but use in house as well. My knowledge grew with many of the sessions provided, but one stood out from others. Not because it was more technical or that I learned something specific that I have been wanting to learn more about; it was that this particular session put a retrospect on what KTL’s Director of Sales and I deal with on an everyday basis: the connection and dependence between our two departments.
April 8, 2015
CRM Service Module: Part 1
Often when discussing a Dynamics CRM it is not uncommon to think of the application solely in the terms of how it can be used for the Sales and Marketing departments. As marketing to prospects and building potential sales are the first interactions companies usually have with a customer it is easy to see why these tend to be focal points for a CRM system. However, critical interactions with those companies do not stop after the sale, they continue on well beyond closing the opportunity and invoicing the order. If you have heard the adage, “It is easier to retain current customers than to acquire new ones,” you know I am speaking of customer service. The customer service module in Dynamics CRM is often forgotten in conversations when speaking of the capabilities of the application yet it is quite a robust piece. To bring light to this often overlooked module of Dynamics CRM over the next few articles we will highlight some of the features.
April 1, 2015
