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

  • I'm going to reply to myself 😛

    I got this far -- but the last piece having problems:

    Code:

    parameters = rs.GetItemParameters(report, historyID, forRendering, values, credentials);

    Console.WriteLine("parameters[0].Name = " + parameters[0].Name);

    Console.WriteLine("parameters[0].DefaultValues = " + parameters[0].DefaultValues);

    The above 3 lines of code worked and I got the output:

    parameters[0].Name = databaseName

    parameters[0].DefaultValues =

    Now All I want to do is to assign a Default Falue for this first parameter (parameters[0], databaseName) so I go:

    rs.SetItemParameters(report, parameters[0].DefaultValues.SetValue("My_DB_Name", ???));

    ??For the '???' part no matter what I put (tried '2', 'parameters[0]' ) it wouldn't satisfy the complier -- keeps compalining "The best overloaded method match for 'System.Array.SetValue(object, params long[])' has some invalid arguments" ...

    ?Can someone give me some tips on WHAT should be inside the ( ) for SetValue ??? THAHK YOU SO MUCH!!!