There are quite some reports in the out of the box installation of Dynamics CRM 4.0, but these sometimes do not match the exact business requirements. Also the reports which can be created by using the Dynamics CRM Report Builder Wizard cannot contain complex calculations or information of more than two entities. When you do export one of these reports and try to edit this in Visual Studio, then
Showing posts with label sqlserver. Show all posts
Showing posts with label sqlserver. Show all posts
Thursday, 18 December 2008
Friday, 4 July 2008
Creating an activity report which includes the related people
Posted on 03:06 by Unknown
In an activity CRM grid, it is not possible to add attributes from the activity type (letter, phonecall etc) itself. The fields to and from on the entities phonecall, letter, fax are therefore not eligable for addition on the CRM grid. It would be very useful to see those though. The same is valid for the to, cc and bcc in email and required and optional attendees in appointments. In this post I
Transform a table column into a CSV field in SQL Server
Posted on 02:52 by Unknown
Imagine that you want to use a related table in your SQL query. You then must return only a single column or otherwise you'll get this SQL error:Msg 512, Level 16, State 1, Line 2Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.What I like to do, is to transform the result table column into a
Monday, 21 January 2008
AttributeInfo.TypeName(int) != AttributeMetadata.Type.Name(float)
Posted on 01:05 by Unknown
You might bump into an error message while importing an entity from a customizations file. The error show could be:Error: lead: AttributeInfo.TypeName(int) != AttributeMetadata.Type.Name(float)The cause of this error is a mismatch in attribute type. Usually a field has been removed in the other environment and has been recreated with another attribute type. The type in your destination CRM system
Tuesday, 27 November 2007
Improve performance of Microsoft Dynamics CRM
Posted on 00:53 by Unknown
The performance of your CRM implementation is one of the key factors for customer acceptance. There are multiple options available for optimizing your system. Here's a list to get started:Microsoft - Optimize Microsoft Dynamics CRM 3.0Microsoft - Optimize Microsoft Dynamics CRM 1.2Aaron Elder - Optimize the CRM Webservice CallsBrein Reid - Reduce the amount of useless calls to IIS 6.0
Tuesday, 27 March 2007
Reducing the transaction log file size in MS SQL 2005
Posted on 03:57 by Unknown
In the past, when using MS SQL 2000, it was fairly easy to reduce the file size used by the transaction log. Just backup the transaction log, perform a shrink command and then the file size has dropped to a minimum.In MS SQL 2005 this won't work. If you do so, then the file might be shrinked a bit, but it is not very small yet. To do this you would need to do the shrink command (including
Thursday, 9 November 2006
Reporting services on another machine
Posted on 05:29 by Unknown
The database server doesn't have to be running on the same server as the CRM application itself. If you follow the installation guide, then everything should work fine. But... Avanade has done this for several clients and sometimes it appears that the reporting might not work. The error message will be:“An error has occurred. For more information, contact your system administrator”or"error 401 –
Monday, 30 October 2006
Error: Deletion Service failed to clean up some tables
Posted on 03:00 by Unknown
Some people have been experiencing the following error message in the event log:Event Type: ErrorEvent Source: MSCRMDeletionServiceEvent Category: NoneEvent ID: 16387Date: DateTime: TimeAM User: N/AComputer: Computer_NameDescription:Error: Deletion Service failed to clean up some tables.Microsoft has a solution for this message. See http://support.microsoft.com/kb/921391/EN-US/ for their
Monday, 3 July 2006
Modifying the fullname
Posted on 06:49 by Unknown
The fullname of a contact is always "firstname lastname". Right? Well, did you know that you can modify this? Go to Settings, System Settings. There you can modify this setting to some other options!Great :) So lets modify the fullname to "lastname, firstname". When saving this setting, CRM warns you that this only works for the new entities and not for the existing entities. If this really is a
Tuesday, 19 July 2005
Full-Text Search is not enabled for the current database
Posted on 07:24 by Unknown
After using the redeployment tools it is sometimes not possible to search for KB articles in CRM. The error which shows up (either on the screen or in the event viewer) is:Full-Text Search is not enabled for the current database. Use sp_fulltext_database to enable full-text search for the database.Here is the resolution:Ensure that the Microsoft search service is running and set to start
Subscribe to:
Posts (Atom)