CRM Musings

RSS Feed Moved

2010-07-23T22:03:00.000Z

Feed Moved: Please update feed from link at http://blog.simonjackson.info.

CRM 4 Import Customisations error "There is insufficient system memory in resource pool 'internal' to run this query."

2010-03-18T10:28:00.000Z

I ran into the below error when importing customisations on to a new CRM 4 install, which had Server 2008 R2 and SQL 2008 on a virtual server with CRM Rollup 9 applied.

There is insufficient system memory in resource pool 'internal' to run this query

Googling only confused me as I develeved into many SQL fourms. In the end the solution was really simple. I'd inadvertantly only allocated 1GB of memory to the machine. I doubled the memery and the import was sucessfull.

Prior to this issue, I also got the below error during the import:

Could not import a Saved Query {5ADB1DD1-2F93-4C65-AC0A-2372E3EAD103} for ObjectTypeCode 9100 because this is a system Saved Query. The Entity you are trying to import is not the same as the one existing in the database even though it has the same name.

Entity 9100 is the report entity, omitting the entity from the import stopped the issue, but I assume this means that you cannot import the report entity from Rollup 7 customisations export to Rollup 9 CRM instance.

CRM 4 Import Export Customisations cool tool

2010-03-17T09:30:00.002Z

I've lost day working out why my CRM customisations have been corrupted because a custom attribute has changed datatype. I've spent hours working out what the exact customisation need to be exported to bring UAT in line with Dev. I've gone cross eyed deleting attributes that are no longer used.

But no more this tool solves these problems and more, totally awesome, look at at it's features:

Console Application, Making it possible to import and export inside nant, msbuild or bat scripts, for example to export the customization each night and “check in” to a source code repository, enabling version control of the customizations. Also to import customizations directly from a MSI installation.
Export Only Modifications, You can export a “clean” customization xml in the beginning of a project and save it in the application folder as “CleanCustomization.xml”, the application will compare the current state and only export the entities that are modified or added.
Remove Deleted Attributes, This feature only applies when importing a customization. When this operation is selected one will be prompted with all attributes that has been removed in the new customization, given the possibility to remove them from the CRM instance.
Changes Attribute data type, When changing an attributes data type and then trying to import it to a CRM instance that still contains the old attribute would normally generate an error. This is now handled and the data inside the old attribute will be converted to the new data type (when possible and logical)
Publish, You can publish the customizations, can also be used at it’s own, for example assigning it to a system wide hotkey for fast access.
Node & Entity Selection, you can select what nodes and entities to import and export. For example only export ISV Config or the Site Map. Possible items to select,

Entities	Workflows	Roles	ISV Config
Sitemap	Templates	Calendar Settings	General Settings
Email Settings	Marketing Settings	Outlook Synchronization	AutoNumbering Settings
And more…

JavaScript Export/Import, This allows you to extract JavaScript to a local folder, where you can work in a proper script editor, and later import them back. You can also create new javascripts in the same folder, just follow the name convention and they will also be imported to the correct entity / event.
Zip support, Now all features works with zipped customizations
Include Related Entities, This features will automatically include related entities to the selected entities, so their relationships are exported and can be reviewed for conflicts. This is recommended during the development process when relationships may change.
Publish Workflows, Publish operation now also publishes workflows

CRM Identify which fields are not being used for any given crm entity

2010-03-16T09:41:00.001Z

We're currently working with a customer who has a CRM 4 deployment that is deemed a failure in the business (this was implemented by another CRM ISV). One of the activities we are undertaking is to simplify the CRM forms as much as possible.

David Jennaway has a small post on identifing unused fields that will be really useful to us to provide evidence which fields are not being used, now if we could just get that data cross referenced with the fields that are actually on the forms or in views....

Use the following SQL to create the stored procedure:
create proc pExcCheckColumnValues @entityName nvarchar(64), @customOnly bit = 0, @maxThreshold int = null
as

declare @attrName nvarchar(50), @sql nvarchar(1024)
declare cur cursor fast_forward for
select a.name from attribute a
join entity e on a.entityid = e.entityid
where e.name = @entityName and a.IsLogical = 0
and ((@customOnly = 1 and a.IsCustomField = 1) or isnull(@customOnly, 0) = 0)

create table #tmp (EntityName nvarchar(64), AttributeName nvarchar(50), ValueCount int)

open cur
fetch next from cur into @attrName
while @@fetch_status = 0
begin
set @sql = 'insert #tmp select ''' + @entityName + ''', ''' + @attrName + ''', count(*) from Filtered' + @entityName + ' where ' + @attrName + ' is not null'
+ case when @maxThreshold is not null then ' having count(*) <= ' + cast(@maxThreshold as nvarchar) else '' end
exec (@sql)
fetch next from cur into @attrName
end

close cur
deallocate cur
select * from #tmp
go

To give an example of how to use the procedure, the following will return all custom attributes of the account, where no more than 10 account records have a value in this field:

exec pExcCheckColumnValues @entityName = 'account', @customOnly = 1, @maxThreshold = 10

CRM 4 : Lookup name label not being displayed

2010-03-15T15:49:00.000Z

I've had an issue for the last couple of weeks that has been difficult to resolve. When users were trying to populate certain lookups on some CRM forms the name was not being displayed for the selected record in the lookup records dialog, but the lookups could be populated from the form assistant. After disabling all javascript I was a bit stumped to see the issue was still present.

I've been using a tool called CRM View Layout replicator to copy the columns in one view to other views. It turns out there is a bug in this tool and when it updates the "lookup view" it updated the preview attribute in the customisation xml, it set it's value to 1 instead of keeping it's origin value of 0. When you select an entity form the lookup records dialog, the system uses the view where preview value is 0 to find the name of a selected entity and populate it in to the lookup on the form.

The fix is to export the entity xml and update preview="1" to preview="0" for all the lookup views (1 per entity) that the tool has been used against and then reimport the xml again.

Here's an example where the preview attribute is incorrect:

CRM 4 Import Organisation fails

2010-03-12T21:10:00.000Z

Today I had an issue where I could not import an organisation into CRM4, I could not get past the map user screen. I found a good forum post but it still didn't resolve the issue my issue.

The import wizard needs the setup user mapped, the setup user is the user that originally created the organisation, if the user has been disabled, or CRM system administrator rights removed then there can be problems during the import process, the below script put's things right. In fact it can even change the setup user if required.

This script will just list all the users and their security roles,

Use this script to set a user as the setup user, just update the set statement with the domain user name and run against the database you want to import.

SET @NewSetupUserDomainName = 'CRM\Administrator'

How to change the user name and the logon name for a user record in Microsoft Dynamics CRM

2010-03-12T14:06:00.000Z

If you change the logon name of a Microsoft Dynamics CRM user record in Active Directory, Microsoft Dynamics CRM can no longer use the logon name to locate the user in Active Directory. Therefore, the Microsoft Dynamics CRM user cannot log on to Microsoft Dynamics CRM.

To make sure that a user can successfully log on to Microsoft Dynamics CRM, change the user name and the logon name for the user record in Microsoft Dynamics CRM. To do this, follow the appropriate steps.

Microsoft Dynamics CRM 4.0

Modify the user account in Active Directory. For example, change the user name, and then change the logon name.
Open Microsoft Dynamics CRM 4.0 as a System Administrator user.
Click Settings, click Administration, click Users, and then open the user record that you want to change.
In the Domain Logon Name box, type an Active Directory user account that is not used by a Microsoft Dynamics CRM 4.0 user record.

Note If all the Active Directory user accounts are used by Microsoft Dynamics CRM 4.0 user records, create a temporary Active Directory user account.
Click Save.
In the Domain Logon Name box, type the Active Directory user account. Then, click Save and Close.

Note The Active Directory user account that you type in this step is the account that is used by a Microsoft Dynamics CRM 4.0 user record. The Microsoft Dynamics CRM 4.0 user record is the record for which you want to change the user name and the logon name in Microsoft Dynamics CRM 4.0.

Source: http://support.microsoft.com/kb/930853

Great Book Professional Enterprise.NET (Wrox Programmer to Programmer)

2010-03-09T20:04:00.000Z

I've just finished reading this book and thought I'd share my thoughts.

Having read Head First Design patterns, (which I think has a unique and great way of teaching patterns), I still couldn't manage to get the patterns in my code. This book however, has finally allowed me to clearly identify and implement some useful patterns in my code, some I was already using but didn't realise! It offers clear explanations of why and how to organise your code into a clear and testable manor. The book has three distinct sections with a total of 12 chapters and presented in a good logical order.

Part I, an Introduction to Practical Enterprise Development, covers the question why and what enterprise architecture and development is, these chapters cover the concepts of enterprise architecture and development talking about Reliability, Flexibility, Separations of Concerns, reusability and maintainability.

Part II, the New Code -- Changing the Way You Build, shows you how you can write and organise your code to support the concepts discussed in part I. It also offers practical learning covering many key concepts in a logical order, amongst other things you will learn about loose coupling, refactoring, TDD, mocking, abstraction, unit testing and a variety of patterns.

Part III, Enterprise Design Patterns, this was the meat for me, effectively covers various design patterns and tools that can be used. For me, some of the best content is in this section, I especially liked the Model-View-Presenter and Model-View-Controller patterns, this part of the book explains why and when these patterns can be used.

In Summary, I would definitely recommend this book, it's a worthwhile read. It taught me so much about what's available out there and what's being used now in software development and will stay as a hands on reference resource going forward.

CRM 4 Multi Entity Type Lookup

2010-02-07T19:43:00.003Z

Create a single lookup on a CRM form that allows the user to select from multiple entity types. Download these two entities to see this in action.

The code is a class that you can implement, so it really should be easy to use. To use the class do the following steps:

On the entity that requires the multi entity type lookup:

Add a N:1 relationship for each entity type that you want in the lookup.
Add the look ups to the form, add one where you want the Multi Entity Type and the others to tab that we will hide from the user.
In the onload paste in the class at the top:
Call the class to setup the lookup
Call the onsave method
Please let me know if you find this useful by posting a comment.

Adding a browse button (html input file control) to a CRM form

2010-02-07T09:29:00.006Z

Here's a quick example of how to put a browse button (html input file control) on a CRM form and then populate another field when it changed. Put this into your onload and update the field name 'new_filepath' in the inputF_onChange method to the name of the field that you would to be populated with the full path.

inputF = document.createElement('input');
inputF.type = 'file';
inputF.onchange = inputF_onChange;

tbl = crmForm.all.tab0.getElementsByTagName('table');
if (tbl && tbl[0]) tbl[0].parentNode.insertBefore(inputF, tbl[0]);


function  inputF_onChange() {
if (inputF && inputF.value)
crmForm.all.new_filepath.DataValue = inputF.value;
}

Here's a list the members exposed by the input type=file object.
http://msdn.microsoft.com/en-us/library/ms535263(VS.85).aspx

It should be noted that the above example will not work for IE8 as JavaScript can no longer read the full path from the value property.

As an alternative I would recommend trying a more supported method, for example, create an ISV page with the input file control and read the path server side and use javascript to populate the control on the parent CRM form.

Microsoft CRM 4.0 Update Rollup 7 and "Internet Explorer has blocked this site from using an ActiveX control in an unsafe manner."

2010-02-04T20:45:00.003Z

Rollup 7 adds a new “Configure CRM” button to setup the Outlook client. The button uses an ActiveX control to read your CRM Outlook client, which can causes IE to display "Internet Explorer has blocked this site from using an ActiveX control in an unsafe manner."

This occurs when you have the Microsoft Office Outlook installed but not configured, or if you are connecting to an organisation other than the organisation for which Microsoft Dynamics CRM for Microsoft Office Outlook is configured.

This issue is mentioned in http://support.microsoft.com/default.aspx/kb/976539

A solution is mentioned here http://support.microsoft.com/kb/2004601

You can either change the IE security zone on the client or update the registry on the server. To update the sever registry, follow these steps:

Open Regedit
Navigate to:HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM
A a new 32bit DWORD called DisableOutlookSetupLink
Set the value to 1 to disable the CRM for Outlook button for all users.

about:blank not always trusted, so not such a good default url for your CRM IFrame

2010-02-03T21:05:00.003Z

Basically when setting a default page for your Crm Forms IFRAME about:blank can have a trust issues in the browser and it's better practice to use /_static/blank.htm instead.

This nice article from those ascentium guys explains why.
http://xrm.ascentium.com/blog/crm/Post612.aspx

Excellent Calendar Control

2009-10-25T10:05:00.004Z

I implemented a shared calendar view for CRM4 at a client, it shows appointments across many different business units and account in consolidated views, we used a third party share point web part by Bamboo Solutions, unfortunately there were many limitations to the control that meant that the implementation was lacking in features, such as adding a new appointment from the control!!

I've come across an excellent calendar control leaving me in doubt that if we ever have to implement a calendar for CRM again this is the control we will use.

Feature rich, excellent usability for the user and relatively cheap. There's a demo page here

Optimising VPC Speed

2008-11-03T20:44:00.005Z

I've started to use the following batch file to stop some unnecessary services in my CRM development virtual machine to help optimise it's speed.

As you can see below this is not specific to CRM so will come in handy for my other environments.

@echo off
@echo -- Stopping unnecessary services for optimal VPC speed
@echo
@echo -- ... Stopping "Help and Support" service
net stop "Help and Support"
@echo -- ... Stopping "Print Spooler" service
net stop "Print Spooler"
@echo -- ... Stopping "Error Reporting Service" service
net stop "Error Reporting Service"
@echo -- ... Stopping "Task Scheduler" service
net stop "Task Scheduler"

Crm Tracing on Server 2008 problem

2008-10-22T07:43:00.004+01:00

I was pulling my hair out trying to get Crm4 tracing working on Server 2008 deployment, I logged onto the server made changes to the tracing registry settings but CRM did create any tracing files. So I double checked them all seemed ok!

At first I thought it was permissions to the trace directory but it transpires this was caused by User Account Control(UAC) virtualising the registry.

http://msdn.microsoft.com/en-us/library/aa965884.aspx

While the registry looked fine to my user account it was a virtual copy! CRM was reading the registry but it didn’t have any trace settings.

Turning off the registry virtualises for the CRM keys, this meant I could change the trace settings. I ran the following from an administrator console to turn off visualisation

REG FLAGS HKLM\Software\Microsoft\MSCRM SET DONT_VIRTUALIZE /s

Alternately I think I could have made the changes to the registry under the context of the CRM Application Process so that CRM would see the changes.

CreateCrmService incorrect url, CrmService fails with 404 - Not Found

2008-10-22T07:05:00.003+01:00

I deployed a plug-in today to one of our clients dev server only to get a strange “404 - Not Found” exception being reported. The exception was raised from the CrmService, the service object was returned from context.CreateCrmService so it should of been ok. Digging deeper I could see that the URL was pointing to localhost which is incorrect as it should have been the host header http://crm.mydomain.fqdn, as always Google had the answer.

I found a great post where George Doubinski has reflected the issue and highlights the CRM bug

There’s a hot-fix for the issue kb950542 at the time of writing this had to be requested from MS.

CRM4 JScript Export Tool

2008-08-31T15:10:00.007+01:00

Joris Kalz has released a small tool to extract the JScript from CRM forms and put them into individual files. His post can be found here.

IMHO I think I'll find this useful for source control and handy when used in conjunction with David Yack's JScript Intellisence solution.

CRM4 Outlook Client Fixes from KB950088

2008-08-31T15:01:00.002+01:00

Microsoft has released a hotfix package for KB950088is a cumulative hotfix which resolve all the issues below:

1. Outlook hangs during initialization (progress toolbar displays “Loading…” and never finishes)

This must-have fix is likely the most common perf/stability issue out there, especially on Outlook 2007. This fix resolves the issue. A current workaround exists by turning off the To Do bar.
http://support.microsoft.com/kb/952724

2. With E-mail Auto Promotion Enabled, Outlook may not close cleanly/properly.

This fix addresses a memory allocation issue that can occur somewhat unpredictably. If your users are using e-mail auto promotion, I encourage you to deploy this hotfix.

http://support.microsoft.com/kb/948121

3. Contacts with birthdays earlier than 1/1/1970 causes Outlook to crash

This was caused by an API change by one of our dependencies.

http://support.microsoft.com/kb/948045

4. Items in Shared Calendars will report Sync Issues

We do not support Shared Calendars in CRM 4.0, we encountered a couple of cases where some code was getting executed against a shared calendar and causing problems.

http://support.microsoft.com/kb/949086

5. Cannot Promote an E-mail where the name of the attached file contains a ‘&’ symbol.

If the attachment to an e-mail contains the ‘&’ symbol, it will fail to track in CRM.

http://support.microsoft.com/kb/949719

6. Selecting Dismiss on Outlook Calendar reminder for Service Activity causes record to change Status Reason back to default value for that record.

Selecting Dismiss on Outlook Calendar reminder for Service Activity causes record to change Status Reason back to default value for that record

http://support.microsoft.com/kb/950475

7. OWA Sent Emails Get Stuck in Outlook Draft Folder When Outlook Is Open And CRMADDIN is Enabled

When you have both Outlook and OWA open, and you have the Microsoft Dynamics CRM client for Microsoft Office Outlook installed, and you send an email form OWA, the email will be stopped in the Draft folder instead of being sent

http://support.microsoft.com/kb/950088

Enable Jscript Intellisense for CRM by Leveraging Visual Studio 2008

2008-08-31T14:24:00.005+01:00

The promise to have Jscript intellisence over the crm JScript object model has me sold
on the book "CRM as a Rapid Development Platform" (electronic version $49.99) by David Yack.

On David's site you can find a videocast demonstrating the benefit's of intellisence for Crm JScript and how to achieve it. Enable CRM JScript Intellisense

As far as I am aware you need to buy the book to obtain the code that helps you achieve the intellisence in VS 2008.

SharePoint List Web Part for Microsoft Dynamics CRM 4.0

2008-08-31T14:12:00.003+01:00

I've been reading the Microsoft Dynamics CRM "Statement of Direction" that's was updated in August 2008. And noticed the following regarding SharePoint List Web Part for Microsoft Dynamics CRM 4.0:

"The current List Web Part for Microsoft Dynamics CRM 3.0 provides a subset of the Microsoft Dynamics CRM 3.0 record list functionality. It allows users to view Microsoft Dynamics CRM 3.0 records as a list from a SharePoint page, open records in Microsoft Dynamics CRM 3.0 from that list, and connect different Microsoft Dynamics CRM 3.0 List Web Parts to filter associated CRM lists. It supports the following versions of SharePoint:
- Microsoft Windows SharePoint Services 2.0
- Microsoft Office SharePoint Portal Server 2003
- Microsoft Office SharePoint Server (MOSS) 2007 (32-bit only)
- Microsoft Windows SharePoint Services (WSS) 3.0 (32-bit only)
The CRM records are displayed in a grid that behaves similarly to the grid within Microsoft Dynamics CRM 3.0. Users who have the proper privileges can perform actions such as create and edit.

Due out in the second half of 2008, there will be an updated SharePoint List Web Part for Microsoft Dynamics CRM 4.0. This web part will have the same features as the previous release but will also support the following:
- The multi-tenancy architecture of Microsoft Dynamics CRM 4.0; the web part is
configured with the Microsoft Dynamics CRM organization that will supply the list data.
- Support for CRM on-premise and Internet Facing Deployments (IFD); support for Microsoft
Dynamics CRM Online will be added in the first half of 2009.
- MUI and language packs in all languages supported by Microsoft Dynamics CRM 4.0
- MOSS and WSS 64-bit environments"

I've been waiting for this upgrade for ages and will be very happy to see it released (in the near future).

Creating SharePoint Sites With CRM Workflow

2008-04-28T18:42:00.002+01:00

Nice post of creating a SharePoint sites using workflow.
http://blogs.msdn.com/ukcrm/archive/2008/04/27/creating-sharepoint-sites-with-crm-workflow.aspx

CRM 4

2007-10-30T11:20:00.000Z

I’ve been following the release of Microsoft CRM 4 with great interest. Having deployed CRM 3 to many clients I’m all too aware of the limitation you hit customising CRM 3.

Philip Richardson is the CRM Lead Program Manager, he has released many of the screen casts below on his blog. These should let you see some of some of the new features in action.

Some of the new features are:

Multi-currency: Oh not just localized versions, but the ability to mix currency choice within one specific company.
Multi-language: The same as above and a big thank you to the team from the many companies with multiple global offices!
Support for roaming profiles when using terminal service environments
Significant development around increased WAN performance
Multi-layers of advanced duplicate detection. A major thank you from me to the team! They went above and beyond on this one (although this demanding little gemstone can always find more to want)
Support for SQL Monitoring and SQL Clusters
Support for alternative deployments
"self updating" installation
Diagnosis and process monitoring
Embedded Auto-Complete on numerous fields
More Bulk Changes and Data Cleansing features
Web Based Mail Merge
A new Report Wizard to empower customers to extract all the data they want to extract in the way they want to extract it
Integration with Office Communicator (think embedded IM)
Presence control (who is on-line)
360 Degree View of the Customer
Cross entity advanced find enhancements
Role based report foundation
New Deployment Wizards which include bulk importing of users from Active Directory
OneNote Integration
A new level of Bi-Directional integration to Excel (Export to Excel, make changes, re-import into DynamicsCRM)
New workflow Wizards, Templates and libraries
Web based/Client Workflow configuration
Break down any workflow into stages
Multi-criteria e-mail tracking. E-mail tracking token can be turned off.
New more flexible licensing options such as device versus user CALs
Role based Report Foundation - Reporting can be dependent on the user's rights, security and roles
New Microsoft Dynamics CRM Resource Center
Reconfiguration/Redesign of the Outlook Client for CRM to allow for the wide variety of outlook footprints and variables in the field
Diagnostic Tools in the Outlook for CRM client
The Windows Workflow Foundation (WWF) with more integration to MOSS (SharePoint)
Many to Many Relationships
System to System Relationships
Pop3 Support/Exchange 2007 Support (64 bit)
Direct External Interface into Dynamics CRM without a required VPN
Asynchronous processing
Offline and On-line use is consistent no change of features when offline
New Data Mapping features
Multiple ways to Authenticate
Various components from within Dynamics CRM can be split out onto different application servers including API Calls, WorkFlow, UI Calls, etc.
Greater Organization Visibility
New Client Migration Toolkit
Multi-Tenant platform for enterprise hosting
E-Mail Topology changed to support more multiple choices of e-mail routing
E-mail routing can be done without Exchange
Reporting stored within the database for easy disaster recovery planning

WSS3 - Hiding Navigation area

2007-07-17T16:29:00.001+01:00

WSS3 / Moss doesn't provide a user interface option for turning off the header or top navigation menu. However, because SharePoint sites use cascading style sheets styles, we can take advantage of cascading style sheets(CSS) and simply hide these items.
To modify the CSS can use a content editor web part. This allows us to add custom content and code that WSS will render on the page. Use the Source Editor enter the following code:

<style type="text/css">
.ms-bodyareaframe {
   padding: 0px;
}
.ms-globalbreadcrumb{
   display: none;
}
.ms-globaltitlearea{
   display: none;
}
.ms-bannerContainer{
   display: none;
}
.ms-titleareaframe{
   display: none;
}
.ms-pagetitleareaframe{
   display: none;
}
.ms-leftareacell{
   display: none;
}
</style>

I also wanted to hide the navigation areas so that a custom AllItems.aspx page could be shown inside CRM Account and CRM Contact forms. Unfortunately these pages do not allow WebParts so I used Microsoft Office SharePoint Designer to create a copy of AllItems.aspx and add the hiding CSS directly into the HTML in the page.

Getting XSD Schema for CRM Entities

2007-06-21T10:46:00.000+01:00

The CRM Metadata Browser can be used to see and document various CRM entities. Another similar thing available is the ability to get the XSD schema for the CRM entities. As you drill into an entity from the metadata browser, you can simply change the directory in the URL or just type it in as follows:

http://yourcrmserver/sdk/xsd/entity.aspx?entity=account

Of course, just change the entity listed at the end with any valid entity schema name.

Thanks to Ryan Farley for posting the info.

I'm using this as I'm adding the XSD to Word 2003 templates, these will be used server side to population CRM data into them and store them in an SharePoint library. I'll post more on this over the next few weeks.

CRM3 – IFrame prompting for credentials

2007-05-01T07:29:00.000+01:00

I had a problem today where new CRM IFrame customisations on various entities were prompting for additional security. The IFrame’s source pages were part of the same CRM site and only used integrated windows authentication in IIS snap-in console. Another symptom was that the pages IE security zone was “Unknown Zone (Mixed)”. Searching the news groups I could see other user have had this issue and that the IFrame has the security="restricted" attribute, this forces IE to re-authenticate the IFrame page for windows security even thought Windows Authentication is being used.

The solution was to un-tick the default setting “restrict cross-frame scripting” in each of the CRM IFrame customizations, this resolved the issue and I once again had happy users, phew!

According to the Working with Microsoft Dynamics CRM 3.0 book (page 455) this setting also does the following:
· Restricts JavaScript and VBScript from executing on the IFrame page
· All hyper links will open in a new browser window

References:
IFrame attributes used with Microsoft CRM
IFrame Security Attribute