Hi,
I'm trying to view my report not prompting for the parameter, but have it passed through the csp code. The ParameterFields property should do this (acc. to docu). But is does not: "Unable to create report viewer. -2147467259".
I'm sure it's just a bit. The report has in total 6 parameters where the last 5 have defaults, only the first (RCountry) needs to be set.
With viewer1
.ReportSource = rptSource
.EnterpriseLogon = iStore.EnterpriseSession
.EnableParameterPrompting = False
.ParameterFields.Item(0) = "Germany"
.URI = CStr( Request.ServerVariables.Item("PATH_INFO") & "?" & Request.ServerVariables.Item("QUERY_STRING"))
End With
If Err.Number <> 0 Then
'There was an error setting up the viewer.
Response.Write "Unable to create report viewer. " & Err.number
Else
'Process the request and launch the viewer.
viewer1.ProcessHttpRequest Request, Response, Session
End If
I'm trying to view my report not prompting for the parameter, but have it passed through the csp code. The ParameterFields property should do this (acc. to docu). But is does not: "Unable to create report viewer. -2147467259".
I'm sure it's just a bit. The report has in total 6 parameters where the last 5 have defaults, only the first (RCountry) needs to be set.
With viewer1
.ReportSource = rptSource
.EnterpriseLogon = iStore.EnterpriseSession
.EnableParameterPrompting = False
.ParameterFields.Item(0) = "Germany"
.URI = CStr( Request.ServerVariables.Item("PATH_INFO") & "?" & Request.ServerVariables.Item("QUERY_STRING"))
End With
If Err.Number <> 0 Then
'There was an error setting up the viewer.
Response.Write "Unable to create report viewer. " & Err.number
Else
'Process the request and launch the viewer.
viewer1.ProcessHttpRequest Request, Response, Session
End If