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
Friday, 4 July 2008
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
Thursday, 3 July 2008
Determine the logged in user
Posted on 08:14 by Unknown
Some time ago I wrote a post around how to show and hide fields based on the logged in user. Apparently this doesn't work for Dynamics CRM 4.0 anymore for two reasons. This post will help you to get it working again.The first one is that you are not allowed to use the <%= approach anymore. You do now have to use the function: Page.Response.Write(string strText);The second reason is that the
MVP for the 3rd consecutive year
Posted on 08:00 by Unknown
Hi Guys,As a reward for community work last year, Microsoft has again reawarded me the Microsoft CRM MVP! I am very much pleased with this award because as one of my colleagues said: Getting to the top is hard, but staying there is even harder!Last year I have spend a lot of time on doing community work again. I have spend a lot of time preparing for presentations like deepdive sessions and CRM
Monday, 23 June 2008
UPDATE: Have a drink with your fellow CRM consultants
Posted on 07:25 by Unknown
For quite some time I've been thinking about organizing a drink for all the Microsoft Dynamics CRM consultants in the Netherlands. Mostly I've been thinking about the format. Who should be invited, should Microsoft be a sponsor etc. From one day to another, these questions were answered by Johan van Dijk. He started the "Dynamics Netwerk Borrel". He organizes drinks for consultants who are
Wednesday, 21 May 2008
Windows Home Server
Posted on 01:31 by Unknown
Who of you guys is working with Windows Home Server (WHS)? Last weeks I've been working with this in my spare time. I've grabbed an old pc, added some harddisk space and memory and installed this product. Now I'm figuring out all of the possibilities. Of course there's the most important feature: Backup. Every night the WHS server wakes up all of my pc's and laptops and makes a backup. Once my
Wednesday, 19 March 2008
Resizing windows
Posted on 06:40 by Unknown
If you have a lot of data on an entity form, then you sometimes do want to force the page to open in full screen mode. There's a small javascript which will allow you to do this. Just add these two lines of code to the form onload of your entity form:window.moveTo(0,0);window.resizeTo(screen.availWidth, screen.availHeight);Also, when you open a custom page you can also set the window size by
Subscribe to:
Posts (Atom)