Tag: Microsoft Dynamics 365

Using World Map \ Bing Map in SSRS Report in Dynamics 365 (and earlier)


Hi,

Recently I was working on a SSRS Report that will show the countries in the world map (Country was a custom entity in our CRM)

To create such a report, drag the Map report item to the report designer.

OOB we do not have world map in the Map Gallery.

Download it from the following location

https://mapgallery.codeplex.com/releases

Copy the download RDL to the following location (in my case – SQL Server Data Tools for VS 2012)

Select the world map

Add a Bing Map layer

Select Basic map

Click Next and select appropriate value

Click on Finish.

Next inside report designer, right click Layer Data

And specify mapping between the spatial and analytical dataset (our custom dataset here which has 2 column in it, name of the country and A2.

Suppose we have following countries in our CRM

The final report with countries highlighted in colors.

Hope it helps..

Bug in New Form Rendering CRM 2016 Update 1 – Add New button not working for Opportunity Product Sub Grid in Opportunity Form.


Today we got one more product bug in case of New Form Rendering

The Add New Button for OOB Inline Edit Sub grid works properly, however for a new custom sub grid it doesn’t work.

The same works properly in case of Legacy Form Rendering.

Clicking on + button opens the new form for Opportunity Product entity

Below are the other issues that we have faced recently in case of New Form Rendering

https://nishantrana.wordpress.com/2016/11/28/onchange-event-getting-fired-on-setvalue-in-crm-2016-update-1-new-form-rendering/

https://nishantrana.wordpress.com/2016/11/25/recommended-field-showing-up-as-required-field-issue-in-dynamics-365/

Hope it helps..

Cannot update a report from a template if the report was not created from a template error while trying to import solution in Dynamics 365


While trying to import a managed solution to our test environment we got the below error

“Cannot update a report from a template if the report was not created from a template”. We got this error on one specific report.

Removing that particular report from the solution and trying the import again fixed the issue for us.

https://community.dynamics.com/crm/f/117/t/150777

Hope it helps..

SQL Timeout Issue while trying to Apply Solution Upgrade in Dynamics 365


Recently in our project we tried implementing solution upgrade to delete some of the components from the existing managed solution.

https://nishantrana.wordpress.com/2016/10/16/how-to-delete-components-from-managed-solution-in-dynamics-crm-2016-without-using-holding-solution/

However, we kept running into SQL time out issue and it didn’t work for us. Finally we raised product support ticket for it and eventually the product support team increased the SQLCommandTimeout to 5 minutes, which helped us to fix the issue.

Crm Exception: Message: Customer lookup [CustomerId] is invalid. Customer lookups can only be associated with 1 Account and 1 Contact error while importing solution in CRM


While trying to import solution to our test environment from our dev environment we got the below error

 “Crm Exception: Message: Customer lookup [CustomerId] is invalid. Customer lookups can only be associated with 1 Account and 1 Contact”

The way we got it fixed

  • Unzip the solution and open customizations.xml file
  • Remove all attributes with name “CustomerId” (Lead, Invoice, Opportunity entity)

g1

  • Find all entity relationships with ReferencingAttributeName equals CustomerId and add to EntityRelationship new attribute: unmodified=”1″

g2

  • Zip solution back and import it.

https://community.dynamics.com/crm/f/117/t/198818

Hope it helps..

Legacy Form Rendering vs New Form Rendering (Turbo Forms) in Dynamics 365


Hi,

Recently we were analyzing performance improvement we’d gain while moving our solution from legacy form rendering to new form rendering.

For this we picked up the opportunity entity, which had good enough customizations (field, tab, sub grid, JavaScript etc.) in it.

Below is result we got using CRM Performance Center

http://blog.cobalt.net/blog/understanding-the-microsoft-dynamics-crm-performance-center

Hope it helps..