Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
SSRS: Problem of setting Multi-Value Parameter programmatically (VB.NET)

Answered SSRS: Problem of setting Multi-Value Parameter programmatically (VB.NET)

  • Thursday, January 17, 2013 12:23 PM
     
     
    Sign In to Vote
    0

    Hello,

    I want to set multiple value parameters of a SSRS-Report (SSRS 2008 R2) programmatically (VB.NET).

    The following statements show hopefully, what I mean:

    ...

    Dim parameters(1) As ParameterValue

    Dim re As New ReportExecutionService

    parameters(0) = New ParameterValue()
    parameters(0).Name = "ProductsID"
    parameters(0).Value = "100"

    parameters(1) = New ParameterValue()
    parameters(1).Name = "ProductsID"
    parameters(1).Value = "200"

    re.SetExecutionParameters(parameters,[...])

    result = re.Render(format, devInfo, extension, _
                           encoding, mimeType, warnings, streamIDs)

    ...

    The report will be generated, but only with one value considered (always the first, here: 100). Can you give me an advice?

    Greetings

     

All Replies