feridun

Activities Report and Activities Detail Report – Circle Colours

The out of the box Activites Report only shows activites that are regarding Opportunities and Cases. The report includes an option to show all. This uses the Activities Detail report which includes colour coding against the activities. By analysing the rdl file for the report the following sets the colour circle to show: IIf(Fields!scheduledend.Value>DateAdd(“d”,7,Now),”ballgr”,IIF(IsNothing(Fields!scheduledend.Value),”ballgr”,IIf(Fields!scheduledend.Value>Now,”ballyl”,”ballrd”))) My […]

Activities Report and Activities Detail Report – Circle Colours Read More »

Customizing Marketing List Views

The CRM application does not allow marketing list views to be customized. However, the views are stored in the savedquerybase table and may in fact be customized. Firstly, we need to find the GUIDs for the relevant views. There are nine views in total, All, Active and Inactive members for Accounts, Contacts and Leads. Query

Customizing Marketing List Views Read More »

Reporting on cases

Reporting on cases and resolutions can be frustrating until you discover that the information recorded in the Resolve Case Dialog window is found in more than one view. When a case is resolved, a special type of activity called a case resolution is added to the case. To write reports on Cases, the following filtered views

Reporting on cases Read More »

Workflows won’t publish

After installing a CRM 4.0 Update Rollup workflows might not publish. The reason may be that the following line is missing from web.config: <authorizedType Assembly=”mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089″ Namespace=”System.Globalization” TypeName=”CultureInfo” Authorized=”True”/> If so, then add the line back in. IISRESET is not needed.

Workflows won’t publish Read More »

Asyncoperationbase table – operationtype, status code and state code

The asyncoperationbase table stores details of system jobs (including workflows). The following table details some of the different job types that are stored in the table. operationtype Description 1 System Event 9 Collect SQM data 10* Workflow Operation 12 Update Match Code 25 Generate Full Text Catalog 27 Update Contract States Note: For entries where

Asyncoperationbase table – operationtype, status code and state code Read More »

Changing country fields to picklists

Changing country fields from free text to picklists is not a trivial undertaking. There are several considerations: 1. The existing country fields cannot be changed to be a picklist2. The country field appears in several record types (account, contact, quote, order, invoice and addresses).3. Addresses are mapped when creating records in the context of other

Changing country fields to picklists Read More »