Wednesday, 9 April 2014

Maximum Size of Solution to Import

Maximum Size of Solution to Import

For Microsoft Dynamics CRM Online the maximum size for a solution is 29.296 MB.
For on-premises Microsoft Dynamics CRM 2011, the default maximum size for a solution is 6 MB but this can be increased as needed.
Change the maximum allowed size by editing the <httpRuntime> element in the web.config file for the application. Edit the executionTimeout and maxRequestLengthattributes to allow for the necessary size. After you finish installing the solution you can set it to the size you want.

SSRS - customer URL Click thru

iif(
 (
  (iif(Fields!customeridEntityName.Value is nothing, 0, 1) +
    iif(Parameters!CRM_URL.Value is nothing, 0, iif(Parameters!CRM_URL.Value = "",0,1))) <> 2),
   System.DBNull.Value,
   iif(Fields!customeridEntityName.Value = "account",
     Parameters!CRM_URL.Value & "?OTC=1&ID={"& Fields!customerid.Value.ToString() &"}",
     iif(Fields!customeridEntityName.Value = "contact",
       Parameters!CRM_URL.Value & "?OTC=2&ID={"& Fields!customerid.Value.ToString() &"}",
       System.DBNull.Value)
   )
)

Thursday, 27 March 2014

CRM 2011/2013 - SSRS Report Drill Through

iif(
 (
  (iif(Fields!customeridEntityName.Value is nothing, 0, 1) +
    iif(Parameters!CRM_URL.Value is nothing, 0, iif(Parameters!CRM_URL.Value = "",0,1))) <> 2),
   System.DBNull.Value,
   iif(Fields!customeridEntityName.Value = "account",
     Parameters!CRM_URL.Value & "?OTC=1&ID={"& Fields!customerid.Value.ToString() &"}",
   iif(Fields!customeridEntityName.Value = "contact",
      Parameters!CRM_URL.Value & "?OTC=2&ID={"& Fields!customerid.Value.ToString() &"}",
      System.DBNull.Value)
   )
)

Wednesday, 22 January 2014

SHA1 Powershell Script

[Reflection.Assembly]::LoadWithPartialName("System.Security") | out-null
$sha1 = new-Object System.Security.Cryptography.SHA1Managed

Function SHA1 {
    Param([string] $fn)

    $obj = New-Object System.Object
    $obj | Add-Member -type NoteProperty -name Name -value $fn

    $v = ""
    if (Test-Path $fn) {
        $a = Get-Item $fn
        if ($a.Attributes -eq 'Directory') { $v = "Directory" }
        else {
            try {
                $file = [System.IO.File]::Open($a.FullName, "open", "read")
                $sha1.ComputeHash($file) | %{ $v += $_.ToString("x2") }
                $file.Dispose()
            }
            catch { $v = "failed to open" }
        }
    }
    else { $v = "invalid path" }
    $obj | Add-Member -type NoteProperty -name SHA1 -value $V
    $obj
}
$TAB = @()
$args | %{
    try {
    Get-ChildItem -r $_ | %{ $TAB += SHA1 $_.FullName }
    }
    catch { }
}
$TAB | Format-Table -autosize -property SHA1,Name

Friday, 5 July 2013

DisableLoopbackCheck

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa]
"DisableLoopbackCheck"=dword:00000001 

Tuesday, 4 June 2013

PowerShell Script to download CRM Rollup 11

import-module bitstransfer
Start-BitsTransfer http://download.microsoft.com/download/A/4/2/A42407F8-C8DF-42BD-AADB-638A2FC87990/CRM2011-Bids-KB2739504-ENU-i386.exe
Start-BitsTransfer http://download.microsoft.com/download/A/4/2/A42407F8-C8DF-42BD-AADB-638A2FC87990/CRM2011-Client-KB2739504-v2-ENU-amd64.exe
Start-BitsTransfer http://download.microsoft.com/download/A/4/2/A42407F8-C8DF-42BD-AADB-638A2FC87990/CRM2011-Client-KB2739504-v2-ENU-i386.exe
Start-BitsTransfer http://download.microsoft.com/download/A/4/2/A42407F8-C8DF-42BD-AADB-638A2FC87990/CRM2011-Mui-KB2739504-ENU-amd64.exe
Start-BitsTransfer http://download.microsoft.com/download/A/4/2/A42407F8-C8DF-42BD-AADB-638A2FC87990/CRM2011-Mui-KB2739504-ENU-i386.exe
Start-BitsTransfer http://download.microsoft.com/download/A/4/2/A42407F8-C8DF-42BD-AADB-638A2FC87990/CRM2011-Router-KB2739504-ENU-amd64.exe
Start-BitsTransfer http://download.microsoft.com/download/A/4/2/A42407F8-C8DF-42BD-AADB-638A2FC87990/CRM2011-Router-KB2739504-ENU-i386.exe
Start-BitsTransfer http://download.microsoft.com/download/A/4/2/A42407F8-C8DF-42BD-AADB-638A2FC87990/CRM2011-Server-KB2739504-v2-ENU-amd64.exe
Start-BitsTransfer http://download.microsoft.com/download/A/4/2/A42407F8-C8DF-42BD-AADB-638A2FC87990/CRM2011-Srs-KB2739504-ENU-amd64.exe
Start-BitsTransfer http://download.microsoft.com/download/A/4/2/A42407F8-C8DF-42BD-AADB-638A2FC87990/CRM2011-Tools-KB2739504-ENU-amd64.exe