crshnbrn66/Deploy-Reports.ps1

## Deploy-Reports.ps1
param
(
    [String] [Parameter(Mandatory)]
    $SolutionFile,
    #this is the evironment that is in the Solution config to read where things need to go (TEST/DEV/QA/Prodution)
    #for example - C:\tfs2013\Test Automated Deployment Sharepoint.rptproj
    [string] [Parameter(Mandatory)] $Environment,
    #this is the name of the Datasource as it exists in Sharepoint without the .rsds extension
    [string] [Parameter(Mandatory)] $DataSource,
    #This is the connection string that will be set for the report data source.
    #this is only necessary if this is the first time the reports are being deployed.

    [string]  [Parameter(Mandatory)]  $connectString,
    #the username that the Datasource will run under
    #defaults to the user that this script is running under
    [string] [Parameter(Mandatory)] $username = "$([environment]::UserDomainName)\$([environment]::Username)",
    [string] [Parameter(Mandatory)] $Password = 'password',
    [string] $reportExtension = '*.rdl',
    [string] $setDataSourceOnly = $false,
    [string] $setCache = $false,
    [string] $cacheValue = '30',
    [string] $cacheFiles = '',
    [string] $datasetFilter = '.rsd'
)
write-output "__________________________________________________________________"
write-output "SolutionFile:`t`t$solutionFile"
Write-output "Environment: `t`t$environment"
write-output "Datasource: `t`t$datasource"
write-output "Connection String: `t`t$connectString"
write-output "Username: `t`t$username"
write-output "Password is not Null:  `t`t$($password -ne $null)"
write-output "reportextension: `t`t$reportExtension"
write-output "SetDatasourceOnly: `t`t$setDataSourceOnly"
Write-Output "SetCache: `t`t$setCache"
Write-Output "CacheValue: `t`t$cacheValue"
Write-Output "CacheFiles: `t`t$($cacheFiles)"
Write-Output "datasetFilter: `t`t$($datasetFilter)"
write-output "__________________________________________________________________"
write-verbose 'fix to set the variable for the setting of the datasource.'
if ($setDatasourceonly -eq 'true')
{$setdatasourceonly = $true	}
else
{$setdatasourceonly = $false}
if ($setCache -eq 'true')
{$setCache = $true}
else
{$setCache = $false}

if ($MyInvocation.MyCommand.Path)
{
    $scriptpath = $MyInvocation.MyCommand.Path
    $d = Split-Path $scriptpath
    write-output -InputObject "Script Directory: `t`t$D"
    import-module "$d\sqlreporting.psd1" -DisableNameChecking -Force
    import-module "$d\subscriptions.psm1" -Force
}
else
{
    import-module .\sqlreporting.psd1 -DisableNameChecking -Force
    import-module ".\subscriptions.psm1" -Force
}
#
if (test-path $solutionfile -pathtype Leaf)
{
    $reportPath = (get-item $solutionfile).DirectoryName
    [xml]$x = get-content $solutionfile
    $test = ($x.Project.Configurations.configuration |Where-Object {$_.name -eq $environment}).options
    $hasSubscriptions = "$(((get-item $reportPath).Parent).FullName)\$((Get-Item $reportPath).Name).subs"

    if (Test-Is2013SharepointUrl $test.targetServerUrl )
    {
        $sharepoint = $true
        $webservice = [System.Net.WebUtility]::UrlDecode(([System.Net.WebUtility]::HtmlDecode("$($test.TargetServerURL)/_vti_bin/ReportServer/ReportService2010.asmx")))
    }
    else
    {
        $u = [uri] $test.targetServerUrl
        $webservice = $u -replace ($u.PathAndQuery), '/ReportServer/ReportService2010.asmx'
        $sharepoint = $false
    }

    Write-output "webservice: `t`t$webservice"
    $dataSourceTarget = [System.Net.WebUtility]::UrlDecode(([System.Net.WebUtility]::HtmlDecode($test.TargetDataSourceFolder)))
    write-output "datasourceTarget: `t`t$datasourceTarget"
    $documentLibrary = [System.Net.WebUtility]::UrlDecode(([System.Net.WebUtility]::HtmlDecode($test.TargetFolder)))
    write-output "DocumentLibrary: `t`t$documentLibrary"
    $d = Get-ChildItem "$reportPath\$datasource*.rds"
    $dataSourceName = $d.name -replace $d.Extension, '' #remove the extension from the reportdatasource physical filename.

    if ($x.project.DataSets.ProjectItem)
    {
        $dataSets = $x.project.DataSets.ProjectItem
    }
    else {$dataSets = $null}

    if ($cacheFiles -match "`r`n")
    {
        Write-Output "CRLF Detected"
        [string[]]$cacheFiles2Set = $cacheFiles -split "`r`n"
    }
    elseif ($cacheFiles -match "`n")
    {
        Write-Output "New line detected"
        [string[]]$cacheFiles2Set = $cacheFiles -split "`n"
    }
    else
    {
        [string[]]$cacheFiles2Set = $cacheFiles -split ','
    }

    $cache = @()
    foreach ($cacheitem in $cacheFiles2Set)
    {
        $Split = $cacheItem -split ','
        if ($Split.count -gt 1)
        {
            $cFile = ($split[0].trimstart()).trimend()
            $cache += [pscustomobject]@{'CacheFile' = $cfile
                'minutes'                           = $Split[1]
            }
        }
        else
        {
            $cFile = ($split[0].trimstart()).trimend()
            $cache += [pscustomobject]@{'CacheFile' = $cfile
                'minutes'                           = $cacheValue
            }
        }
    }

    if ($dataSets)
    {
        write-output "DataSetNames: `t`t$(($DataSets.name -replace '.rsd', '' ) -join ",")"
        #$dataSetnames = $DataSets.name
        $TargetDatasetFolder = [System.Net.WebUtility]::UrlDecode(([System.Net.WebUtility]::HtmlDecode($test.TargetDatasetFolder)))
        write-output "TargetDatasetFolder: `t`t$TargetDatasetFolder"
    }

    ############################# integrated SSRS Deployment in first if ############################
    if ($sharepoint)    # this is to tell the script that we are deploying to sharepoint
    {
        $results = Deploy-SharepointReports -datasource $DataSource -documentLibrary $documentlibrary -dataSourceTarget $datasourceTarget -webservice $webservice -username $username -password $password -datasets $datasets -datasetFilter $datasetfilter -TargetDatasetFolder $targetDataSetFolder -reportPath $reportPath -reportExtension $reportExtension -connectString $connectString -setDatasourceOnly $setDatasourceOnly -cachefiles2Set $cache
        Write-Output $results
    }

    ############################# native SSRS Deployment in below here ##############################
    else #Native SSRS deployment falls in here
    {
        $results = Deploy-NativeSSRS -datasource $DataSource -documentLibrary $documentlibrary -dataSourceTarget $datasourceTarget -webservice $webservice -username $username -password $password -datasets $datasets -datasetFilter $datasetfilter -TargetDatasetFolder $targetDataSetFolder -reportPath $reportPath -reportExtension $reportExtension -connectString $connectString -setDatasourceOnly $setDatasourceOnly -cachefiles2Set $cache
        Write-Output $results
    }
    Write-Output $results
    write-output 'Checking for Subscriptions'
    if (test-path $hasSubscriptions)
    {
        Push-Location
        $reportFilter = "*.config"
        write-output "__________________________________________________________________"
        Write-Output "  This Project has Data Driven Subscriptions updating .... "
        Write-Output "Documentlibrary: `t`t$documentLibrary"
        Write-Output "Webservice: `t`t$webservice"
        Write-Output "Subscription Directory: `t`t$hasSubscriptions"
        Write-Output "Subscription FileEXT: `t`t$reportFilter"
        write-output "__________________________________________________________________"
        $ssrsproxy = New-WebServiceProxy -uri $webservice -UseDefaultCredential -namespace 'SSRSProxy' -class 'ReportService2010'
        if ( (Get-CustomPowerShellClasses).name -ne 'ssrsobject')
        {
            Write-Verbose "Check to make sure the proxy hasn't already been created"
            try
            {
                 . Invoke-SSRSobject
            }
            catch
            {
                Write-Output "Check the $proxy address"
                break
            }
        }
        else
        {
            Throw "This Script can only execute once because of the dependency on an object [ssrsobject]"
            break
        }
        write-verbose "Checking to see if our object has already been created once if it has we don't want to create it again or the object won't be 'findable'"

        $currentSubscriptions = get-subscriptions -ssrsproxy $ssrsproxy -site $documentLibrary -DataDriven
        $sourceSubscriptions = New-DeserializedSSRSObject -path $hasSubscriptions -filter $reportFilter
        write-output "______________Subscription Removal________________________________"
        foreach ($sub in $currentSubscriptions)
        {
            if ($sourceSubscriptions | Where-Object {$_.description -eq $sub.description})
            {
                Write-Verbose "Found the same subscription will delete it in the destination to allow for a re-create"
                write-verbose "delete $($subscription.subscription.SubscriptionID)"
                Remove-DatadrivenSubscription -ssrsproxy $ssrsproxy -subscriptionid $sub.subscription.subscriptionid
                Write-Output "Removed Subscription $($sub.description)"
            }
        }
        write-output "__________________________________________________________________"

        write-output "______________Subscription Adds__________________________________"
        foreach ($sub in $sourceSubscriptions)
        {
            Write-Verbose "Creating new subscription for $($sub.description)"
            try
            {
                Write-Output "Attempting to create Subscripion $($sub.description)"
                $status = New-DataDrivenSubscription -ssrsproxy $ssrsproxy -reportObject $sub -destination $documentLibrary
                write-output "Added $($sub.description) from $($sub.subscription.path) $status"
            }
            Catch
            {
                "Error was $_"
                $line = $_.InvocationInfo.ScriptLineNumber
                "Error was in Line $line ------ Exiting"
                Break
            }
            #$s += $status
            #Write-Output "Created Subscription $($sub.description) datasource and id $status"
        }
        write-output "__________________________________________________________________"

        Pop-Location
    }
}
else
{
    Throw "SolutionFile cannot be blank or a directory $solutionFile"
}


## subscriptions.psm1
#requires -version 5.0

function Get-DataDrivenSubscriptionProperties
{
    param([object] $Subscription,
        [object]$ssrsproxy)
    $ssrsobject = [SSRSObject]::New()
    $sid = $Subscription.SubscriptionID
    $ddextensionSettings = $ddDataRetrievalPlan = $ddDescription = $ddactive = $ddstatus = $ddeventtype = $ddmatchdata = $ddparameters = $Null
    $ddOwner = $ssrsproxy.GetDataDrivenSubscriptionProperties($sid, [ref]$ddextensionSettings, [ref]$ddDataRetrievalPlan`
            , [ref]$ddDescription, [ref]$ddactive, [ref]$ddstatus, [ref]$ddeventtype, [ref]$ddmatchdata, [ref]$ddparameters)

    $ssrsobject.subscription = $Subscription
    $ssrsobject.Owner = $ddOwner
    $ssrsobject.ExtensionSettings = $ddextensionSettings
    $ssrsobject.Description = $ddDescription
    $ssrsobject.DataRetrievalPlan = $ddDataRetrievalPlan
    $ssrsobject.Active = $ddactive
    $ssrsobject.Status = $ddstatus
    $ssrsobject.EventType = $ddeventtype
    $ssrsobject.MatchData = $ddmatchdata
    $ssrsobject.Parameters = $ddparameters
    $ssrsobject
    <# [PSCustomObject]@{
        'Owner' = $ddOwner
        'extensionSettings' = $ddextensionSettings
        'DataRetrievalPlan' = $ddDataRetrievalPlan
        'Description' = $ddDescription
        'active' = $ddactive
        'status' =$ddstatus
        'eventtype' =$ddeventtype
        'matchdata' = $ddmatchdata
        'parameters' = $ddparameters
      } #>
}

function Get-SubscriptionProperties
{
    param([string]$Subscription,
        [object]$ssrsproxy)
    $subextensionSettings = $subDataRetrievalPlan = $subDescription = $subactive = $substatus = $subeventtype = $submatchdata = $subparameters = $Null

    $subOwner = $ssrsproxy.GetSubscriptionProperties($subscription.SubscriptionID, [ref]$subextensionSettings, [ref]$subDescription, [ref]$subactive, [ref]$substatus, [ref]$subeventtype, [ref]$submatchdata, [ref]$subparameters)
    $ssrsobject = [SSRSObject]::New()
    $ssrsobject.subscription = $Subscription
    $ssrsobject.Owner = $subOwner
    $ssrsobject.ExtensionSettings = $subextensionSettings
    $ssrsobject.Description = $subDescription
    $ssrsobject.DataRetrievalPlan = $subDataRetrievalPlan
    $ssrsobject.Active = $subactive
    $ssrsobject.Status = $substatus
    $ssrsobject.EventType = $subeventtype
    $ssrsobject.MatchData = $submatchdata
    $ssrsobject.Parameters = $subparameters
    <#
      [PSCustomObject]@{
        'Owner' = $subOwner
        'extensionSettings' = $subextensionSettings
        'Description' = $subDescription
        'active' = $subactive
        'status' =$substatus
        'eventtype' =$subeventtype
        'matchdata' = $submatchdata
        'parameters' = $subparameters
      }
    #>
}

function Get-Subscriptions
{
    #Returns a nested object with each
    param([object]$ssrsproxy, [string]$site, [switch]$DataDriven)
    #write-verbose 'Path to where the reports are must be specified to get the subscriptions you want.. Root (/) does not seem to get everything'
    $items = $ssrsproxy.ListChildren($site, $true) | Where-Object {$_.typename -eq 'report'}
    $subprops = $ddProps = @()
    foreach ($item in $items)
    {
        $subs = $ssrsproxy.ListSubscriptions($item.path)
        write-verbose "found $($subs.count) subscriptions for $($item.Name)"

        if ($subs)
        {
            foreach ($sub in $subs)
            {

                if ($sub.isdatadriven -eq 'true')
                {
                    $ddProps += Get-DataDrivenSubscriptionProperties -subscription $sub -ssrsproxy $ssrsproxy
                }
                elseif (-not $DataDriven)
                {
                    $subProps += Get-SubscriptionProperties -subscriptionid $sub -ssrsproxy $ssrsproxy
                }

            }
        }
    }
    if ($DataDriven)
    {$ddProps}
    else
    {
        $subprops
    }
}

function New-XMLSubscriptionfile
{
    [CmdletBinding()]
    [Alias()]
    param([psobject]$subscriptionObject, [string]$path, [string]$extension = '.xml')
    if (test-path $path -PathType Leaf)
    {
        $path = split-path $path

    }
    if (-not(test-path $path))
    {
        mkdir $path
    }
    foreach ($sub in $subscriptionObject)
    {
        $reportName = (($sub.subscription.report).split('.'))[0]
        $filename = "$path\$reportName$extension"
        $sub | Export-Clixml -Depth 100  -path $filename
    }
}

function New-JsonSubscriptionFile
{
    [CmdletBinding()]
    [Alias()]
    param([psobject]$subscriptionObject, [string]$path)
    if (test-path $path -PathType Leaf)
    {
        $path = split-path $path

    }
    if (-not(test-path $path))
    {
        mkdir $path
    }
    foreach ($sub in $subscriptionObject)
    {
        $reportName = (($sub.subscription.report).split('.'))[0]
        $filename = "$path\$reportName.json"
        $sub | convertto-json -Depth 100  | out-file $filename
    }
}

Function Export-DataDrivenSubscriptions
{
    param([object]$ssrsproxy, [string]$site, [string]$path, [switch]$json, [string]$extension)
    $subs = get-subscriptions -ssrsproxy $ssrsproxy -site $site -DataDriven
    if ($json)
    {New-JsonSubscriptionFile -subscriptionObject $subs -path $path -extension $extension}
    else
    {New-XMLSubscriptionfile -subscriptionObject $subs -path $Path -extension $extension}

}
function Get-ReportSubscriptions
{
    param([object]$ssrsproxy, [string]$path)

    $subscription = $ssrsproxy.ListSubscriptions($path)

    $subscription
}

function New-DeserializedSSRSObject
{
    param($path, $filter = '*.xml')
    $reportFiles = Get-ChildItem $path -Filter $filter
    $reports = @()

    foreach ($file in $reportFiles)
    {
        try
        {
            $reportobject = Import-Clixml -path ($file.fullname) -ErrorAction Ignore
        }
        catch
        {
            Write-Verbose 'using error action ignore to ensure we only get files that are acctually cli xml files.'
            write-verbose 'swallowing error'
            $reportobject = $Null
        }

        If ($reportobject.subscription)
        {
            Write-Verbose "Create a object of type ExtensionSettings"
            $extensionSettings = New-Object -typename 'SSRSProxy.ExtensionSettings'
            $extensionSettings.Extension = $reportobject.extensionSettings.Extension
            $paramvalues = @()
            foreach ($parameterField in $reportobject.extensionSettings.ParameterValues)
            {
                if ($parameterfield.psobject.Properties.name[0] -eq 'ParameterName') #rebuild the object into an extenstion setting this one contains a parameter field reference
                {
                    $a = [SSRSProxy.ParameterFieldReference]::new()
                    Write-Verbose 'Create a object of type ParameterField reference.'
                    $a.FieldAlias = $parameterfield.fieldalias
                    $a.ParameterName = $parameterfield.ParameterName
                }
                elseif ($parameterfield.psobject.Properties.name[0] -eq 'Name') #rebuild the object into an extension settings object this one contains a param value
                {
                    $a = [SSRSProxy.ParameterValue]::New()
                    Write-Verbose 'Create a object of type ParameterValue reference.'
                    $a.Label = $parameterField.Label
                    $a.Name = $parameterField.Name
                    $a.Value = $parameterField.Value
                }
                $paramvalues += $a
            }
            $extensionSettings.ParameterValues = [ssrsproxy.parametervalueorfieldreference[]]$paramvalues

            [SSRSProxy.DataRetrievalPlan]$DataRetrievalPlan = New-Object SSRSProxy.DataRetrievalPlan
            Write-Verbose 'Create a object of type DataRetrievalPlan reference.'
            #[SSRSProxy.DataSourceReference]$item = $reportobject.DataRetrievalPlan.Item
            $DataRetrievalPlan.DataSet = $reportobject.DataRetrievalPlan.DataSet
            [SSRSProxy.DataSourceReference]$dsReference = $reportobject.DataRetrievalPlan.Item

            Write-Verbose "Datasource Reference $dsreference use the value for the datasource you want this data driven report to consume"
            $DataRetrievalPlan.Item = $dsReference
            $description = $reportobject.Description
            $eventtype = $reportobject.eventtype
            $matchdata = $reportobject.matchdata

            #$b = [Ssrsproxy.parameterfieldreference]::new()
            $paramvalues = @()
            foreach ($parameterField in $reportobject.parameters)
            {
                if ($parameterfield.psobject.Properties.name[0] -eq 'ParameterName') #rebuild the object into an extenstion setting this one contains a parameter field reference
                {
                    $a = [SSRSProxy.ParameterFieldReference]::new()
                    Write-Verbose 'Create a object of type ParameterField reference.'
                    $a.FieldAlias = $parameterfield.fieldalias
                    $a.ParameterName = $parameterfield.ParameterName
                }
                elseif ($parameterfield.psobject.Properties.name[0] -eq 'Name') #rebuild the object into an extension settings object this one contains a param value
                {
                    $a = [SSRSProxy.ParameterValue]::New()
                    Write-Verbose 'Create a object of type ParameterValue reference.'
                    $a.Label = $parameterField.Label
                    $a.Name = $parameterField.Name
                    $a.Value = $parameterField.Value
                }
                $paramvalues += $a
            }
            Write-Verbose 'Create a object of type parameterfieldreference reference.'
            #$b.FieldAlias = $reportobject.parameters.fieldalias
            #$b.ParameterName = $reportobject.parameters.ParameterName
            $ParameterValueOrFieldReference = [Ssrsproxy.parameterfieldreference[]]$paramvalues

            $itemPath = "$($reportobject.subscription.report)"
            $reports += [PSCustomObject]@{
                'itemPath'                       = $itempath
                'extensionSettings'              = $extensionsettings
                'DataRetrievalPlan'              = $DataRetrievalPlan
                'description'                    = $description
                'eventtype'                      = $eventtype
                'matchdata'                      = $matchdata
                'ParameterValueOrFieldReference' = $ParameterValueOrFieldReference
            }
        }
    }
    $reports
}

function New-DataDrivenSubscription
{
    param([object]$ssrsproxy,
        [Object]$reportObject,
        [string]$destination = '/Reports'
    )
    $src = $dest = $null
    Write-Verbose "function asssumes that a report object has been created to push to the destination"
    $src = ([uri]$reportobject.DataRetrievalPlan.Item.reference).absoluteuri
    $dest = (([uri]$destination).absoluteuri)
    if ($dest)
    {
        if ($dest.EndsWith('/'))
        {
            $dest.trimend('/')
        }
    }
    [SSRSProxy.DataSourceReference]$dsReference = $reportobject.DataRetrievalPlan.Item

    if ($src -and $dest) #since .aboluteuri is only present with an actual uri this will let us know this is an actual uri.
    {
        write-verbose "source and destination are sharepoint"
        $datasourceName = $src -split '/' | Select-Object -last 1
        $src = $src -replace "/$datasourceName", ''
        $dsReference.Reference = ((([uri]$reportobject.DataRetrievalPlan.Item.Reference).AbsoluteUri) -replace $src, $dest)
        $reportObject.itempath = ("$destination/$($reportobject.itempath)")
        $dsReference.Reference
    }
    elseif ($src -and (-not $dest))
    {
        write-verbose "source is sharepoint destintation is native"
        $datasourceName = $src -split '/' | Select-Object -last 1
        $dest = $destination
        $src = $src -replace "/$datasourceName", ''
        $dsReference.Reference = ((([uri]$reportobject.DataRetrievalPlan.Item.reference).AbsoluteUri) -replace $src, $dest).Trim('.rsds')
        $reportObject.itemPath = ("$destination/$($reportobject.itempath)").trim('.rdl')
        $dsReference.Reference
    }
    elseif ($dest -and (-not $src))
    {
        write-verbose "destination is sharepoint and source is native"
        $src = $reportobject.DataRetrievalPlan.Item.reference
        $datasourceName = $src -split '/' | Select-Object -last 1
        $src = $src -replace "/$datasourceName", ''
        $dsReference.Reference = ($src -replace $src, "$dest/$datasourceName")
        $reportObject.itemPath = ("$destination/$($reportobject.itempath)")
        $dsReference.Reference
    }
    else
    {
        write-verbose "destination and source are native"
        $dest = $destination.trimend('/')
        $src = $reportobject.DataRetrievalPlan.Item.reference
        $datasourceName = $src -split '/' | Select-Object -last 1

        $src = $src.trimend("/$datasourceName")
        $dsReference.Reference = (($reportobject.DataRetrievalPlan.Item.reference).trimend("/$datasourcename") -replace $src, "$dest/$datasourcename").trim('.rsds')
        $reportObject.itemPath = ("$destination/$($reportobject.itempath)").trim('rdl')
        $dsReference.Reference
    }
    $reportObject.DataRetrievalPlan.Item = $dsReference
    try
    {
        Write-Verbose "Now that the object is re-constituted we can put this in the SSRS instance we wish to push it to"
        if (($reportObject.ParameterValueOrFieldReference.fieldalias) -and ($reportObject.ParameterValueOrFieldReference.ParameterName))
        {
            $ParameterValueOrFieldReference = $reportObject.ParameterValueOrFieldReference
        }
        else {  $ParameterValueOrFieldReference = $Null}
        $status = $ssrsproxy.CreateDataDrivenSubscription($reportObject.itempath , $reportObject.extensionsettings , $reportObject.DataRetrievalPlan, $reportObject.description, $reportObject.eventtype, $reportObject.matchdata, $ParameterValueOrFieldReference)
    }
    Catch
    {
        $line = $_.InvocationInfo.ScriptLineNumber
        $err = "Error was $_ `nError was in Line $line"
        $err = $err + $error[0]
        $err += "($reportObject.itempath , $reportObject.extensionsettings , $reportObject.DataRetrievalPlan,  $reportObject.description, $reportObject.eventtype, $reportObject.matchdata, $ParameterValueOrFieldReference)"
        Throw "Something is wrong check errors $err"

    }

    $status
    #>
}
function Remove-DatadrivenSubscription
{
    param([object]$ssrsproxy,
        [string]$SubscriptionId)

    try
    {
        $ssrsproxy.DeleteSubscription($SubscriptionId)
    }
    catch
    {
        "Error was $_"
        $line = $_.InvocationInfo.ScriptLineNumber
        "Error was in Line $line"
    }
}
<#class SSRSObject
{
    [SSRSProxy.Subscription[]]$subscription
    [string]$Owner
    [SSRSProxy.ExtensionSettings]$ExtensionSettings
    [SSRSProxy.DataRetrievalPlan]$DataRetrievalPlan
    [string]$Description
    [SSRSProxy.ActiveState]$Active
    [string]$Status
    [string]$EventType
    [string]$MatchData
    [object]$Schedule
    [SSRSProxy.ParameterValueOrFieldReference[]]$Parameters

}#>
function Invoke-SSRSobject
{
    $ssrsobject = @'
class SSRSObject
{
    [SSRSProxy.Subscription[]]$subscription
    [string]$Owner
    [SSRSProxy.ExtensionSettings]$ExtensionSettings
    [SSRSProxy.DataRetrievalPlan]$DataRetrievalPlan
    [string]$Description
    [SSRSProxy.ActiveState]$Active
    [string]$Status
    [string]$EventType
    [string]$MatchData
    [SSRSProxy.ParameterValueOrFieldReference[]]$Parameters

}
'@
    Invoke-Expression $ssrsobject
    #. $ExecutionContext.InvokeCommand.NewScriptBlock($ssrsobject)
}
function Get-CustomPowerShellClasses
{
   [appdomain]::CurrentDomain.GetAssemblies() | Where-Object { $_.GetCustomAttributes($false) | Where-Object { $_ -is [System.Management.Automation.DynamicClassImplementationAssemblyAttribute]} } | ForEach-Object { $_.GetTypes() | Where-Object IsPublic }
}
	param
	(
	[String] [Parameter(Mandatory)]
	$SolutionFile,
	#this is the evironment that is in the Solution config to read where things need to go (TEST/DEV/QA/Prodution)
	#for example - C:\tfs2013\Test Automated Deployment Sharepoint.rptproj
	[string] [Parameter(Mandatory)] $Environment,
	#this is the name of the Datasource as it exists in Sharepoint without the .rsds extension
	[string] [Parameter(Mandatory)] $DataSource,
	#This is the connection string that will be set for the report data source.
	#this is only necessary if this is the first time the reports are being deployed.

	[string] [Parameter(Mandatory)] $connectString,
	#the username that the Datasource will run under
	#defaults to the user that this script is running under
	[string] [Parameter(Mandatory)] $username = "$([environment]::UserDomainName)\$([environment]::Username)",
	[string] [Parameter(Mandatory)] $Password = 'password',
	[string] $reportExtension = '*.rdl',
	[string] $setDataSourceOnly = $false,
	[string] $setCache = $false,
	[string] $cacheValue = '30',
	[string] $cacheFiles = '',
	[string] $datasetFilter = '.rsd'
	)
	write-output "__________________________________________________________________"
	write-output "SolutionFile:`t`t$solutionFile"
	Write-output "Environment: `t`t$environment"
	write-output "Datasource: `t`t$datasource"
	write-output "Connection String: `t`t$connectString"
	write-output "Username: `t`t$username"
	write-output "Password is not Null: `t`t$($password -ne $null)"
	write-output "reportextension: `t`t$reportExtension"
	write-output "SetDatasourceOnly: `t`t$setDataSourceOnly"
	Write-Output "SetCache: `t`t$setCache"
	Write-Output "CacheValue: `t`t$cacheValue"
	Write-Output "CacheFiles: `t`t$($cacheFiles)"
	Write-Output "datasetFilter: `t`t$($datasetFilter)"
	write-output "__________________________________________________________________"
	write-verbose 'fix to set the variable for the setting of the datasource.'
	if ($setDatasourceonly -eq 'true')
	{$setdatasourceonly = $true }
	else
	{$setdatasourceonly = $false}
	if ($setCache -eq 'true')
	{$setCache = $true}
	else
	{$setCache = $false}

	if ($MyInvocation.MyCommand.Path)
	{
	$scriptpath = $MyInvocation.MyCommand.Path
	$d = Split-Path $scriptpath
	write-output -InputObject "Script Directory: `t`t$D"
	import-module "$d\sqlreporting.psd1" -DisableNameChecking -Force
	import-module "$d\subscriptions.psm1" -Force
	}
	else
	{
	import-module .\sqlreporting.psd1 -DisableNameChecking -Force
	import-module ".\subscriptions.psm1" -Force
	}
	#
	if (test-path $solutionfile -pathtype Leaf)
	{
	$reportPath = (get-item $solutionfile).DirectoryName
	[xml]$x = get-content $solutionfile
	$test = ($x.Project.Configurations.configuration \|Where-Object {$_.name -eq $environment}).options
	$hasSubscriptions = "$(((get-item $reportPath).Parent).FullName)\$((Get-Item $reportPath).Name).subs"

	if (Test-Is2013SharepointUrl $test.targetServerUrl )
	{
	$sharepoint = $true
	$webservice = [System.Net.WebUtility]::UrlDecode(([System.Net.WebUtility]::HtmlDecode("$($test.TargetServerURL)/_vti_bin/ReportServer/ReportService2010.asmx")))
	}
	else
	{
	$u = [uri] $test.targetServerUrl
	$webservice = $u -replace ($u.PathAndQuery), '/ReportServer/ReportService2010.asmx'
	$sharepoint = $false
	}

	Write-output "webservice: `t`t$webservice"
	$dataSourceTarget = [System.Net.WebUtility]::UrlDecode(([System.Net.WebUtility]::HtmlDecode($test.TargetDataSourceFolder)))
	write-output "datasourceTarget: `t`t$datasourceTarget"
	$documentLibrary = [System.Net.WebUtility]::UrlDecode(([System.Net.WebUtility]::HtmlDecode($test.TargetFolder)))
	write-output "DocumentLibrary: `t`t$documentLibrary"
	$d = Get-ChildItem "$reportPath\$datasource*.rds"
	$dataSourceName = $d.name -replace $d.Extension, '' #remove the extension from the reportdatasource physical filename.

	if ($x.project.DataSets.ProjectItem)
	{
	$dataSets = $x.project.DataSets.ProjectItem
	}
	else {$dataSets = $null}

	if ($cacheFiles -match "`r`n")
	{
	Write-Output "CRLF Detected"
	[string[]]$cacheFiles2Set = $cacheFiles -split "`r`n"
	}
	elseif ($cacheFiles -match "`n")
	{
	Write-Output "New line detected"
	[string[]]$cacheFiles2Set = $cacheFiles -split "`n"
	}
	else
	{
	[string[]]$cacheFiles2Set = $cacheFiles -split ','
	}

	$cache = @()
	foreach ($cacheitem in $cacheFiles2Set)
	{
	$Split = $cacheItem -split ','
	if ($Split.count -gt 1)
	{
	$cFile = ($split[0].trimstart()).trimend()
	$cache += [pscustomobject]@{'CacheFile' = $cfile
	'minutes' = $Split[1]
	}
	}
	else
	{
	$cFile = ($split[0].trimstart()).trimend()
	$cache += [pscustomobject]@{'CacheFile' = $cfile
	'minutes' = $cacheValue
	}
	}
	}

	if ($dataSets)
	{
	write-output "DataSetNames: `t`t$(($DataSets.name -replace '.rsd', '' ) -join ",")"
	#$dataSetnames = $DataSets.name
	$TargetDatasetFolder = [System.Net.WebUtility]::UrlDecode(([System.Net.WebUtility]::HtmlDecode($test.TargetDatasetFolder)))
	write-output "TargetDatasetFolder: `t`t$TargetDatasetFolder"
	}

	############################# integrated SSRS Deployment in first if ############################
	if ($sharepoint) # this is to tell the script that we are deploying to sharepoint
	{
	$results = Deploy-SharepointReports -datasource $DataSource -documentLibrary $documentlibrary -dataSourceTarget $datasourceTarget -webservice $webservice -username $username -password $password -datasets $datasets -datasetFilter $datasetfilter -TargetDatasetFolder $targetDataSetFolder -reportPath $reportPath -reportExtension $reportExtension -connectString $connectString -setDatasourceOnly $setDatasourceOnly -cachefiles2Set $cache
	Write-Output $results
	}

	############################# native SSRS Deployment in below here ##############################
	else #Native SSRS deployment falls in here
	{
	$results = Deploy-NativeSSRS -datasource $DataSource -documentLibrary $documentlibrary -dataSourceTarget $datasourceTarget -webservice $webservice -username $username -password $password -datasets $datasets -datasetFilter $datasetfilter -TargetDatasetFolder $targetDataSetFolder -reportPath $reportPath -reportExtension $reportExtension -connectString $connectString -setDatasourceOnly $setDatasourceOnly -cachefiles2Set $cache
	Write-Output $results
	}
	Write-Output $results
	write-output 'Checking for Subscriptions'
	if (test-path $hasSubscriptions)
	{
	Push-Location
	$reportFilter = "*.config"
	write-output "__________________________________________________________________"
	Write-Output " This Project has Data Driven Subscriptions updating .... "
	Write-Output "Documentlibrary: `t`t$documentLibrary"
	Write-Output "Webservice: `t`t$webservice"
	Write-Output "Subscription Directory: `t`t$hasSubscriptions"
	Write-Output "Subscription FileEXT: `t`t$reportFilter"
	write-output "__________________________________________________________________"
	$ssrsproxy = New-WebServiceProxy -uri $webservice -UseDefaultCredential -namespace 'SSRSProxy' -class 'ReportService2010'
	if ( (Get-CustomPowerShellClasses).name -ne 'ssrsobject')
	{
	Write-Verbose "Check to make sure the proxy hasn't already been created"
	try
	{
	. Invoke-SSRSobject
	}
	catch
	{
	Write-Output "Check the $proxy address"
	break
	}
	}
	else
	{
	Throw "This Script can only execute once because of the dependency on an object [ssrsobject]"
	break
	}
	write-verbose "Checking to see if our object has already been created once if it has we don't want to create it again or the object won't be 'findable'"

	$currentSubscriptions = get-subscriptions -ssrsproxy $ssrsproxy -site $documentLibrary -DataDriven
	$sourceSubscriptions = New-DeserializedSSRSObject -path $hasSubscriptions -filter $reportFilter
	write-output "______________Subscription Removal________________________________"
	foreach ($sub in $currentSubscriptions)
	{
	if ($sourceSubscriptions \| Where-Object {$_.description -eq $sub.description})
	{
	Write-Verbose "Found the same subscription will delete it in the destination to allow for a re-create"
	write-verbose "delete $($subscription.subscription.SubscriptionID)"
	Remove-DatadrivenSubscription -ssrsproxy $ssrsproxy -subscriptionid $sub.subscription.subscriptionid
	Write-Output "Removed Subscription $($sub.description)"
	}
	}
	write-output "__________________________________________________________________"

	write-output "______________Subscription Adds__________________________________"
	foreach ($sub in $sourceSubscriptions)
	{
	Write-Verbose "Creating new subscription for $($sub.description)"
	try
	{
	Write-Output "Attempting to create Subscripion $($sub.description)"
	$status = New-DataDrivenSubscription -ssrsproxy $ssrsproxy -reportObject $sub -destination $documentLibrary
	write-output "Added $($sub.description) from $($sub.subscription.path) $status"
	}
	Catch
	{
	"Error was $_"
	$line = $_.InvocationInfo.ScriptLineNumber
	"Error was in Line $line ------ Exiting"
	Break
	}
	#$s += $status
	#Write-Output "Created Subscription $($sub.description) datasource and id $status"
	}
	write-output "__________________________________________________________________"

	Pop-Location
	}
	}
	else
	{
	Throw "SolutionFile cannot be blank or a directory $solutionFile"
	}
	#requires -version 5.0

	function Get-DataDrivenSubscriptionProperties
	{
	param([object] $Subscription,
	[object]$ssrsproxy)
	$ssrsobject = [SSRSObject]::New()
	$sid = $Subscription.SubscriptionID
	$ddextensionSettings = $ddDataRetrievalPlan = $ddDescription = $ddactive = $ddstatus = $ddeventtype = $ddmatchdata = $ddparameters = $Null
	$ddOwner = $ssrsproxy.GetDataDrivenSubscriptionProperties($sid, [ref]$ddextensionSettings, [ref]$ddDataRetrievalPlan`
	, [ref]$ddDescription, [ref]$ddactive, [ref]$ddstatus, [ref]$ddeventtype, [ref]$ddmatchdata, [ref]$ddparameters)

	$ssrsobject.subscription = $Subscription
	$ssrsobject.Owner = $ddOwner
	$ssrsobject.ExtensionSettings = $ddextensionSettings
	$ssrsobject.Description = $ddDescription
	$ssrsobject.DataRetrievalPlan = $ddDataRetrievalPlan
	$ssrsobject.Active = $ddactive
	$ssrsobject.Status = $ddstatus
	$ssrsobject.EventType = $ddeventtype
	$ssrsobject.MatchData = $ddmatchdata
	$ssrsobject.Parameters = $ddparameters
	$ssrsobject
	<# [PSCustomObject]@{
	'Owner' = $ddOwner
	'extensionSettings' = $ddextensionSettings
	'DataRetrievalPlan' = $ddDataRetrievalPlan
	'Description' = $ddDescription
	'active' = $ddactive
	'status' =$ddstatus
	'eventtype' =$ddeventtype
	'matchdata' = $ddmatchdata
	'parameters' = $ddparameters
	} #>
	}

	function Get-SubscriptionProperties
	{
	param([string]$Subscription,
	[object]$ssrsproxy)
	$subextensionSettings = $subDataRetrievalPlan = $subDescription = $subactive = $substatus = $subeventtype = $submatchdata = $subparameters = $Null

	$subOwner = $ssrsproxy.GetSubscriptionProperties($subscription.SubscriptionID, [ref]$subextensionSettings, [ref]$subDescription, [ref]$subactive, [ref]$substatus, [ref]$subeventtype, [ref]$submatchdata, [ref]$subparameters)
	$ssrsobject = [SSRSObject]::New()
	$ssrsobject.subscription = $Subscription
	$ssrsobject.Owner = $subOwner
	$ssrsobject.ExtensionSettings = $subextensionSettings
	$ssrsobject.Description = $subDescription
	$ssrsobject.DataRetrievalPlan = $subDataRetrievalPlan
	$ssrsobject.Active = $subactive
	$ssrsobject.Status = $substatus
	$ssrsobject.EventType = $subeventtype
	$ssrsobject.MatchData = $submatchdata
	$ssrsobject.Parameters = $subparameters
	<#
	[PSCustomObject]@{
	'Owner' = $subOwner
	'extensionSettings' = $subextensionSettings
	'Description' = $subDescription
	'active' = $subactive
	'status' =$substatus
	'eventtype' =$subeventtype
	'matchdata' = $submatchdata
	'parameters' = $subparameters
	}
	#>
	}

	function Get-Subscriptions
	{
	#Returns a nested object with each
	param([object]$ssrsproxy, [string]$site, [switch]$DataDriven)
	#write-verbose 'Path to where the reports are must be specified to get the subscriptions you want.. Root (/) does not seem to get everything'
	$items = $ssrsproxy.ListChildren($site, $true) \| Where-Object {$_.typename -eq 'report'}
	$subprops = $ddProps = @()
	foreach ($item in $items)
	{
	$subs = $ssrsproxy.ListSubscriptions($item.path)
	write-verbose "found $($subs.count) subscriptions for $($item.Name)"

	if ($subs)
	{
	foreach ($sub in $subs)
	{

	if ($sub.isdatadriven -eq 'true')
	{
	$ddProps += Get-DataDrivenSubscriptionProperties -subscription $sub -ssrsproxy $ssrsproxy
	}
	elseif (-not $DataDriven)
	{
	$subProps += Get-SubscriptionProperties -subscriptionid $sub -ssrsproxy $ssrsproxy
	}

	}
	}
	}
	if ($DataDriven)
	{$ddProps}
	else
	{
	$subprops
	}
	}

	function New-XMLSubscriptionfile
	{
	[CmdletBinding()]
	[Alias()]
	param([psobject]$subscriptionObject, [string]$path, [string]$extension = '.xml')
	if (test-path $path -PathType Leaf)
	{
	$path = split-path $path

	}
	if (-not(test-path $path))
	{
	mkdir $path
	}
	foreach ($sub in $subscriptionObject)
	{
	$reportName = (($sub.subscription.report).split('.'))[0]
	$filename = "$path\$reportName$extension"
	$sub \| Export-Clixml -Depth 100 -path $filename
	}
	}

	function New-JsonSubscriptionFile
	{
	[CmdletBinding()]
	[Alias()]
	param([psobject]$subscriptionObject, [string]$path)
	if (test-path $path -PathType Leaf)
	{
	$path = split-path $path

	}
	if (-not(test-path $path))
	{
	mkdir $path
	}
	foreach ($sub in $subscriptionObject)
	{
	$reportName = (($sub.subscription.report).split('.'))[0]
	$filename = "$path\$reportName.json"
	$sub \| convertto-json -Depth 100 \| out-file $filename
	}
	}

	Function Export-DataDrivenSubscriptions
	{
	param([object]$ssrsproxy, [string]$site, [string]$path, [switch]$json, [string]$extension)
	$subs = get-subscriptions -ssrsproxy $ssrsproxy -site $site -DataDriven
	if ($json)
	{New-JsonSubscriptionFile -subscriptionObject $subs -path $path -extension $extension}
	else
	{New-XMLSubscriptionfile -subscriptionObject $subs -path $Path -extension $extension}

	}
	function Get-ReportSubscriptions
	{
	param([object]$ssrsproxy, [string]$path)

	$subscription = $ssrsproxy.ListSubscriptions($path)

	$subscription
	}

	function New-DeserializedSSRSObject
	{
	param($path, $filter = '*.xml')
	$reportFiles = Get-ChildItem $path -Filter $filter
	$reports = @()

	foreach ($file in $reportFiles)
	{
	try
	{
	$reportobject = Import-Clixml -path ($file.fullname) -ErrorAction Ignore
	}
	catch
	{
	Write-Verbose 'using error action ignore to ensure we only get files that are acctually cli xml files.'
	write-verbose 'swallowing error'
	$reportobject = $Null
	}

	If ($reportobject.subscription)
	{
	Write-Verbose "Create a object of type ExtensionSettings"
	$extensionSettings = New-Object -typename 'SSRSProxy.ExtensionSettings'
	$extensionSettings.Extension = $reportobject.extensionSettings.Extension
	$paramvalues = @()
	foreach ($parameterField in $reportobject.extensionSettings.ParameterValues)
	{
	if ($parameterfield.psobject.Properties.name[0] -eq 'ParameterName') #rebuild the object into an extenstion setting this one contains a parameter field reference
	{
	$a = [SSRSProxy.ParameterFieldReference]::new()
	Write-Verbose 'Create a object of type ParameterField reference.'
	$a.FieldAlias = $parameterfield.fieldalias
	$a.ParameterName = $parameterfield.ParameterName
	}
	elseif ($parameterfield.psobject.Properties.name[0] -eq 'Name') #rebuild the object into an extension settings object this one contains a param value
	{
	$a = [SSRSProxy.ParameterValue]::New()
	Write-Verbose 'Create a object of type ParameterValue reference.'
	$a.Label = $parameterField.Label
	$a.Name = $parameterField.Name
	$a.Value = $parameterField.Value
	}
	$paramvalues += $a
	}
	$extensionSettings.ParameterValues = [ssrsproxy.parametervalueorfieldreference[]]$paramvalues

	[SSRSProxy.DataRetrievalPlan]$DataRetrievalPlan = New-Object SSRSProxy.DataRetrievalPlan
	Write-Verbose 'Create a object of type DataRetrievalPlan reference.'
	#[SSRSProxy.DataSourceReference]$item = $reportobject.DataRetrievalPlan.Item
	$DataRetrievalPlan.DataSet = $reportobject.DataRetrievalPlan.DataSet
	[SSRSProxy.DataSourceReference]$dsReference = $reportobject.DataRetrievalPlan.Item

	Write-Verbose "Datasource Reference $dsreference use the value for the datasource you want this data driven report to consume"
	$DataRetrievalPlan.Item = $dsReference
	$description = $reportobject.Description
	$eventtype = $reportobject.eventtype
	$matchdata = $reportobject.matchdata

	#$b = [Ssrsproxy.parameterfieldreference]::new()
	$paramvalues = @()
	foreach ($parameterField in $reportobject.parameters)
	{
	if ($parameterfield.psobject.Properties.name[0] -eq 'ParameterName') #rebuild the object into an extenstion setting this one contains a parameter field reference
	{
	$a = [SSRSProxy.ParameterFieldReference]::new()
	Write-Verbose 'Create a object of type ParameterField reference.'
	$a.FieldAlias = $parameterfield.fieldalias
	$a.ParameterName = $parameterfield.ParameterName
	}
	elseif ($parameterfield.psobject.Properties.name[0] -eq 'Name') #rebuild the object into an extension settings object this one contains a param value
	{
	$a = [SSRSProxy.ParameterValue]::New()
	Write-Verbose 'Create a object of type ParameterValue reference.'
	$a.Label = $parameterField.Label
	$a.Name = $parameterField.Name
	$a.Value = $parameterField.Value
	}
	$paramvalues += $a
	}
	Write-Verbose 'Create a object of type parameterfieldreference reference.'
	#$b.FieldAlias = $reportobject.parameters.fieldalias
	#$b.ParameterName = $reportobject.parameters.ParameterName
	$ParameterValueOrFieldReference = [Ssrsproxy.parameterfieldreference[]]$paramvalues

	$itemPath = "$($reportobject.subscription.report)"
	$reports += [PSCustomObject]@{
	'itemPath' = $itempath
	'extensionSettings' = $extensionsettings
	'DataRetrievalPlan' = $DataRetrievalPlan
	'description' = $description
	'eventtype' = $eventtype
	'matchdata' = $matchdata
	'ParameterValueOrFieldReference' = $ParameterValueOrFieldReference
	}
	}
	}
	$reports
	}

	function New-DataDrivenSubscription
	{
	param([object]$ssrsproxy,
	[Object]$reportObject,
	[string]$destination = '/Reports'
	)
	$src = $dest = $null
	Write-Verbose "function asssumes that a report object has been created to push to the destination"
	$src = ([uri]$reportobject.DataRetrievalPlan.Item.reference).absoluteuri
	$dest = (([uri]$destination).absoluteuri)
	if ($dest)
	{
	if ($dest.EndsWith('/'))
	{
	$dest.trimend('/')
	}
	}
	[SSRSProxy.DataSourceReference]$dsReference = $reportobject.DataRetrievalPlan.Item

	if ($src -and $dest) #since .aboluteuri is only present with an actual uri this will let us know this is an actual uri.
	{
	write-verbose "source and destination are sharepoint"
	$datasourceName = $src -split '/' \| Select-Object -last 1
	$src = $src -replace "/$datasourceName", ''
	$dsReference.Reference = ((([uri]$reportobject.DataRetrievalPlan.Item.Reference).AbsoluteUri) -replace $src, $dest)
	$reportObject.itempath = ("$destination/$($reportobject.itempath)")
	$dsReference.Reference
	}
	elseif ($src -and (-not $dest))
	{
	write-verbose "source is sharepoint destintation is native"
	$datasourceName = $src -split '/' \| Select-Object -last 1
	$dest = $destination
	$src = $src -replace "/$datasourceName", ''
	$dsReference.Reference = ((([uri]$reportobject.DataRetrievalPlan.Item.reference).AbsoluteUri) -replace $src, $dest).Trim('.rsds')
	$reportObject.itemPath = ("$destination/$($reportobject.itempath)").trim('.rdl')
	$dsReference.Reference
	}
	elseif ($dest -and (-not $src))
	{
	write-verbose "destination is sharepoint and source is native"
	$src = $reportobject.DataRetrievalPlan.Item.reference
	$datasourceName = $src -split '/' \| Select-Object -last 1
	$src = $src -replace "/$datasourceName", ''
	$dsReference.Reference = ($src -replace $src, "$dest/$datasourceName")
	$reportObject.itemPath = ("$destination/$($reportobject.itempath)")
	$dsReference.Reference
	}
	else
	{
	write-verbose "destination and source are native"
	$dest = $destination.trimend('/')
	$src = $reportobject.DataRetrievalPlan.Item.reference
	$datasourceName = $src -split '/' \| Select-Object -last 1

	$src = $src.trimend("/$datasourceName")
	$dsReference.Reference = (($reportobject.DataRetrievalPlan.Item.reference).trimend("/$datasourcename") -replace $src, "$dest/$datasourcename").trim('.rsds')
	$reportObject.itemPath = ("$destination/$($reportobject.itempath)").trim('rdl')
	$dsReference.Reference
	}
	$reportObject.DataRetrievalPlan.Item = $dsReference
	try
	{
	Write-Verbose "Now that the object is re-constituted we can put this in the SSRS instance we wish to push it to"
	if (($reportObject.ParameterValueOrFieldReference.fieldalias) -and ($reportObject.ParameterValueOrFieldReference.ParameterName))
	{
	$ParameterValueOrFieldReference = $reportObject.ParameterValueOrFieldReference
	}
	else { $ParameterValueOrFieldReference = $Null}
	$status = $ssrsproxy.CreateDataDrivenSubscription($reportObject.itempath , $reportObject.extensionsettings , $reportObject.DataRetrievalPlan, $reportObject.description, $reportObject.eventtype, $reportObject.matchdata, $ParameterValueOrFieldReference)
	}
	Catch
	{
	$line = $_.InvocationInfo.ScriptLineNumber
	$err = "Error was $_ `nError was in Line $line"
	$err = $err + $error[0]
	$err += "($reportObject.itempath , $reportObject.extensionsettings , $reportObject.DataRetrievalPlan, $reportObject.description, $reportObject.eventtype, $reportObject.matchdata, $ParameterValueOrFieldReference)"
	Throw "Something is wrong check errors $err"

	}

	$status
	#>
	}
	function Remove-DatadrivenSubscription
	{
	param([object]$ssrsproxy,
	[string]$SubscriptionId)

	try
	{
	$ssrsproxy.DeleteSubscription($SubscriptionId)
	}
	catch
	{
	"Error was $_"
	$line = $_.InvocationInfo.ScriptLineNumber
	"Error was in Line $line"
	}
	}
	<#class SSRSObject
	{
	[SSRSProxy.Subscription[]]$subscription
	[string]$Owner
	[SSRSProxy.ExtensionSettings]$ExtensionSettings
	[SSRSProxy.DataRetrievalPlan]$DataRetrievalPlan
	[string]$Description
	[SSRSProxy.ActiveState]$Active
	[string]$Status
	[string]$EventType
	[string]$MatchData
	[object]$Schedule
	[SSRSProxy.ParameterValueOrFieldReference[]]$Parameters

	}#>
	function Invoke-SSRSobject
	{
	$ssrsobject = @'
	class SSRSObject
	{
	[SSRSProxy.Subscription[]]$subscription
	[string]$Owner
	[SSRSProxy.ExtensionSettings]$ExtensionSettings
	[SSRSProxy.DataRetrievalPlan]$DataRetrievalPlan
	[string]$Description
	[SSRSProxy.ActiveState]$Active
	[string]$Status
	[string]$EventType
	[string]$MatchData
	[SSRSProxy.ParameterValueOrFieldReference[]]$Parameters

	}
	'@
	Invoke-Expression $ssrsobject
	#. $ExecutionContext.InvokeCommand.NewScriptBlock($ssrsobject)
	}
	function Get-CustomPowerShellClasses
	{
	[appdomain]::CurrentDomain.GetAssemblies() \| Where-Object { $_.GetCustomAttributes($false) \| Where-Object { $_ -is [System.Management.Automation.DynamicClassImplementationAssemblyAttribute]} } \| ForEach-Object { $_.GetTypes() \| Where-Object IsPublic }
	}