Parameter Problem
I have created a custom assembly to display the parameter names using the GetReportParameters method. The parameters show through the preview screen in reporting services, but as soon as I deploy it and view the report through Report Manager it shows '#Error'.
What can I do? Any Help?
Thank You
When I run my report through 'DebugLocal' mode.
it breaks here:
Public Class ParameterList
Public Shared Function GetParameterNames()
Dim rs As New ReportingService
rs.Credentials = System.Net.CredentialCache.DefaultCredentials:(
Dim report As String = "/Commission Reports/Detailed Broker Commission Bordereaux"
Dim forRendering As Boolean = False
Dim historyID As String = Nothing
Dim values As ParameterValue() = Nothing
Dim credentials As DataSourceCredentials() = Nothing
Dim strParam As String = ""
Dim Parameters() As ReportParameter
Parameters = rs.GetReportParameters(report, historyID, forRendering, values, credentials)
If Not (Parameters Is Nothing) Then
Dim rp As ReportParameter
For Each rp In Parameters
strParam = rp.Prompt & strParam
Next rp
End If
Return strParam
End Function
End Class
The message reads :
"Request for the permission of type 'System.Security.Permissions.EnvironmentPermission ,
mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed."
Any help would be appreciated
Thanks
|