Home Forums SQL Server 2005 Business Intelligence How to SetItemParameters for a report in SSRS 2008 using web services through SSIS package Script Task RE: How to SetItemParameters for a report in SSRS 2008 using web services through SSIS package Script Task

  • Hello mikehe.info, Ravi,

    I am stuck in the exact same step trying to set linked reports default values and such trying to use the SetItemParameters method. My syntax is VB and here is what I do in the code below.

    I would really appreciate your assistance on this,

    Take care,

    Public Sub Main()

    rs.Credentials = System.Net.CredentialCache.DefaultCredentials

    Dim report As String = "/MyFolder/MySubFolder/Test Linked Report"

    Try

    dim param as new ItemParameter()

    param.Name = "LastNameContains"

    dim myDefaultValues(0) as String

    myDefaultValues(0) = "oo"

    param.DefaultValues = myDefaultValues

    rs.SetItemParameters(report, param)

    Catch e As SoapException

    Console.WriteLine(e.Detail.InnerXml.ToString())

    End Try

    End Sub 'Main