c# - 如何将报告名称、参数和凭据从 .net 中的其他网络表单传递给 ssrs 报告

Question

我正在使用 vs2013 & SSRS Report 2008R2 Advance Express Edition。我有常见的 reportviewer 网络表单，即

    <form id="CommonReport" runat="server">
    <asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>
    <rsweb:ReportViewer ID="RV" runat="server" Font-Names="Verdana" Font-Size="8pt" Height="464px" ProcessingMode="Remote" WaitMessageFont-Names="Verdana" WaitMessageFont-Size="14pt" Width="661px">
    </rsweb:ReportViewer>
<div>
</div>
</form>

我想从其他网络表单传递报告名称、参数和 sql 凭据(即 sql server 名称、用户名和密码)。

请帮忙，我从一周开始就在尝试。我做了以下代码，但它询问我用户名和密码，我正在输入 manulay，但我需要通过 programitcaly

 private void showReport()
    {
        string SSRS = ConfigurationManager.AppSettings["SSRS"];
        ReportViewer1.Reset();
        ReportViewer1.ProcessingMode = ProcessingMode.Remote;
        ReportViewer1.ServerReport.ReportServerUrl = new Uri(SSRS); ;// new Uri(urlReportServer); //Set the ReportServer Url
        ReportViewer1.ServerReport.ReportPath = "/sampleReport";
        ReportViewer1.ShowCredentialPrompts = true;
        ReportParameter reptParam = new ReportParameter("proposalId", proposalId.Text);
        ReportViewer1.ServerReport.SetParameters(reptParam);
        ReportViewer1.ServerReport.Refresh();

    }

Answer 1

单击 here 查看 DataSourceCredentialsType
您可以通过

添加 Report DataSource Credential

reportViewer1.ServerReport.SetDataSourceCredentials(new[] { new DataSourceCredentials() { Name = "XXX", Password = "XXXXXX" } });