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)
   )
)

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

DisableLoopbackCheck

Windows Registry Editor Version 5.00

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

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

Microsoft.Crm.Setup.Server.GrantConfigDBDatabaseAccessAction failed. Windows NT user or group 'MYDOMAIN\SQLAccessGroup' not found. Check the name again. - Pablo Peralta's Blog

Microsoft.Crm.Setup.Server.GrantConfigDBDatabaseAccessAction failed. Windows NT user or group 'MYDOMAIN\SQLAccessGroup' not found. Check the name again. - Pablo Peralta's Blog:

'via Blog this'

Web Resources for Microsoft Dynamics CRM

File File extensions Type Webpage (HTML) .htm, .html 1 Style Sheet (CSS) .css 2 Script (JScript) .js 3 Data (XML) .xml 4 Image (PNG) .png 5 Image (JPG) .jpg 6 Image (GIF) .gif 7 Silverlight (XAP) .xap 8 StyleSheet (XSL) .xsl, .xslt 9 Image (ICO) .ico 10 http://msdn.microsoft.com/en-us/library/gg309473.aspx

Start-BitsTransfer [PowerShell]

Start-BitsTransfer:

'via Blog this'