feridun

Custom Sorting in SSRS Reports

To sort rows in a dataset you can choose a column in the dataset in the properties of the tablix or other report element. Or if you need a custom sort where the sorting isn’t alphabetical or numerical you can add code to the report and then call the code in an expression in the sorting […]

Custom Sorting in SSRS Reports Read More »

Data Encryption Key

Microsoft Dynamics CRM 2013 introduces encryption of password fields in the SQL database. Encryption is performed at the organization level and the keys are stored in the OrganizationProperties table in MSCRM_CONFIG. There are two rows for each organization. In each row the columns shown in the table below are populated. Column Notes ID Organization ID

Data Encryption Key Read More »

Users get “Unauthorized Access” errors when using ADFS

When the ADFS Token-sgining and Token-Decrypting certificates in ADFS are automatically renewed, users in CRM might not be able to login. They receive HTTP 401 Unauthorized Access is denied errors. This occurs because CRM is still using the expired ADFS token certificates. To resolve this reconfigure Claims-based Authentication and Internet-Facing deployment in CRM. This article

Users get “Unauthorized Access” errors when using ADFS Read More »

ISV.Config

In CRM 2011, isv.config is not used to store custom buttons, tabs and menus as in earlier versions. The only item that I think isv.config is used for is to customize the appearance of the service calendar.

ISV.Config Read More »

Deployment Settings

CRM has several deployment wide settings which are stored in the DeploymentProperties table in the configuration database (usually MSCRM_CONFIG). It is not recommended to modify the values in the table directly you may sometimes need to change values. The recommended method is usually to use a PowerShell script. Some of the settings are described in the following

Deployment Settings Read More »

A new book on Microsoft Dynamics CRM report writing

Fellow MVP, Damian Sinay, has published a book on report writing for Dynamics CRM. Writing reports for Microsoft Dynamics CRM is an area that needs more coverage and I was particularly pleased to see the publication of Microsoft Dynamics CRM 2011 Reporting from PACKT Publishing. You can find the book at http://www.packtpub.com/microsoft-dynamics-crm-2011-reporting/book where there is

A new book on Microsoft Dynamics CRM report writing Read More »