Report parameter question

Hi there,

I am a tad confused with an exception that I get whet trying to render

a report to pdf. I pass 2 arraylists which contains the name and value

of the parameters. I iterate through these lists (which are of equal

lenght) and set the parameters. I am very new to this so I am sure that

I am doing something stupid somewhere in the code below:

' Create instance of save dialog and set default

' filename and filter

saveReportDialog = New SaveFileDialog

saveReportDialog.Filter = GetFilterString(pFormat)

saveReportDialog.FileName = pName

' Open the save file dialog

Dim dr As DialogResult = saveReportDialog.ShowDialog()

If dr = DialogResult.OK Then

Dim fileName As String = saveReportDialog.FileName

Dim historyID As String = Nothing

Dim deviceInfo As String = Nothing

Dim showHide As String = Nothing

Dim param() As ParameterValue = New

ParameterValue(pParameterValuesArrayList.Count) {}

Dim credentials As DataSourceCredentials() = Nothing

Dim results() As [Byte]

Dim encoding As String

Dim mimeType As String

Dim warnings As Warning() = Nothing

Dim reportHistoryParameters As ParameterValue() = Nothing

Dim streamIDs As String() = Nothing

'Iterate through the array of parameters and set the report parameters

Dim i As Integer

For i = 0 To pParameterValuesArrayList.Count - 1

param(i) = New ParameterValue

param(i).Name = pParameterNamesArrayList(i)

param(i).Value = pParameterValuesArrayList(i)

Next

'Exectute the report and save it into a file.

Try

results = rs.Render(ReportItem.Path, pFormat, historyID, deviceInfo,

param, credentials, showHide, encoding, mimeType,

reportHistoryParameters, warnings, streamIDs)

Dim stream As FileStream = File.OpenWrite(fileName)

stream.Write(results, 0, results.Length)

stream.Close()

Catch exception As Exception

HandleException(exception)

End Try

End If
when trying to execute the red line of code, I get the following error which confuses:

an exception has occured: The value of parameter 'Parameters' is not valid.

I don't even have a parameter called 'Parameters' . When debugging, I

have determined that the arraylists contain the values they are

supposed to so now I am in need of expertise of all you smart people

here :)

Thanks

MichaelWhat is the error message? Does the report seem to execute just fine when running it through the SSRS\reports website?|||Hi there,

The error I get is in the code... the message reads:

an exception has occured: The value of parameter 'Parameters' is not valid.

The report never opens from whithin my application but does work from the development environment.

The confusing thing is that the only parameter I have is called

"@.MemberID" and not "Parameters", so I don't know what this error

message means. I you look at the code I posted above, the exception is

thrown when I ty to render the report.

Regards

|||Hi, I feel it is necessary to say that I solved my own problem.

It was a more fundamental mistake. I have not converted the parameters

to be strings and thereby it was in invalid. What I did to solve this

problem was:

Dim i As Integer

For i = 0 To pParameterValuesArrayList.Count - 1

parameters(i) = New ParameterValue

parameters(i).Name = CStr(pParameterNamesArrayList(i))

parameters(i).Value = CStr(pParameterValuesArrayList(i))

Next

This worked fine :)