User-1312722619 posted
Hi experts,
I have a reportviewer control which is running well on a form. I dont receive any error message. I can pass parameters successfully.
The problem starts after placing Reportview control into a grid. I need several reports for different parameters at the same time. In this case, i receive boring "The
request failed with HTTP status 401: Unauthorized" error. There is no reason to receive this message as reportviewer working on the form seperate.
Is there any restriction not to use ReportViewer in the gridview. Please see my codes below.
ASPX
<asp:GridView ID="GridViewProjectsForChart" runat="server" AutoGenerateColumns="False"
DataKeyNames="ProjectID" DataSourceID="SqlDataSourceProjectsForChart"
EnableModelValidation="True" ShowHeader="False">
<Columns>
<asp:TemplateField >
<ItemTemplate>
<asp:Label ID="LabelProjectID" runat="server" Text='<%# Bind("ProjectID") %>' CssClass="hidepanel"></asp:Label>
<rsweb:ReportViewer ID="ReportViewerReportProjectSummaryChartByCash" runat="server" ProcessingMode="Remote"
ShowCredentialPrompts="False" ShowDocumentMapButton="False" ShowFindControls="False"
ShowPageNavigationControls="False" ShowParameterPrompts="False" ShowPromptAreaButton="False"
ShowToolBar="False" ShowZoomControl="False" Visible="false"
SizeToReportContent="True" ZoomMode="FullPage" AsyncRendering="False">
<ServerReport
DisplayName="MyReport" ReportPath="/karadumanco/reports/ReportProjectSummaryChartByCash"
ReportServerUrl="https://rs2k801.discountasp.net/ReportServer" />
</rsweb:ReportViewer>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSourceProjectsForChart" runat="server"
ConnectionString="<%$ ConnectionStrings:MERCURYConnectionString %>"
SelectCommand="SELECT ProjectID
FROM Table1_Project
WHERE (ContractCurrency IS NOT NULL) AND (ContractAmount IS NOT NULL)
ORDER BY ProjectName ASC">
</asp:SqlDataSource>
VBA
Imports System.Net
Imports System.Security.Principal
Imports Microsoft.Reporting.WebForms
Imports Microsoft.ReportingServices
Partial Class po_trackerSummaryChart
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
End Sub
Protected Sub GridViewProjectsForChart_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles GridViewProjectsForChart.RowDataBound
Dim ReportViewerReportProjectSummaryChartByCash As ReportViewer = DirectCast(e.Row.FindControl("ReportViewerReportProjectSummaryChartByCash"), ReportViewer)
Dim LabelProjectID As Label = DirectCast(e.Row.FindControl("LabelProjectID"), Label)
If ReportViewerReportProjectSummaryChartByCash IsNot Nothing Then
ReportViewerReportProjectSummaryChartByCash.Visible = True
ReportViewerReportProjectSummaryChartByCash.Reset()
ReportViewerReportProjectSummaryChartByCash.ServerReport.ReportPath = "/karadumanco/reports/ReportProjectSummaryChartByCash"
ReportViewerReportProjectSummaryChartByCash.ServerReport.ReportServerUrl = New System.Uri("https://rs2k801.discountasp.net/ReportServer")
ReportViewerReportProjectSummaryChartByCash.ServerReport.ReportServerCredentials = New MyReportServerCredentials()
Dim myparamProjectID As ReportParameter
Dim myparamsProjectID As New List(Of ReportParameter)
myparamProjectID = New ReportParameter("ProjectID", LabelProjectID.Text)
myparamsProjectID.Add(myparamProjectID)
ReportViewerReportProjectSummaryChartByCash.ServerReport.SetParameters(myparamsProjectID)
ReportViewerReportProjectSummaryChartByCash.ServerReport.Refresh()
End If
End Sub
End Class
<Serializable()> _
Public NotInheritable Class MyReportServerCredentials
Implements IReportServerCredentials
Public ReadOnly Property ImpersonationUser() As WindowsIdentity _
Implements IReportServerCredentials.ImpersonationUser
Get
'Use the default windows user. Credentials will be
'provided by the NetworkCredentials property.
Return Nothing
End Get
End Property
Public ReadOnly Property NetworkCredentials() As ICredentials _
Implements IReportServerCredentials.NetworkCredentials
Get
Return New NetworkCredential("xxx", "xxx", "xxx")
End Get
End Property
Public Function GetFormsCredentials(ByRef authCookie As Cookie, ByRef userName As String, ByRef password As String, ByRef authority As String) As Boolean _
Implements IReportServerCredentials.GetFormsCredentials
authCookie = Nothing
userName = Nothing
password = Nothing
authority = Nothing
'Not using form credentials
Return False
End Function
End Class
