Crystal Report Export to PDF using Parameter in VB.NET

0

aspx page

<asp:Button ID="btnPDF" runat="server" Text="PDF Format" onclick="btnPDF_Click" />
<CR:CrystalReportViewer ID="CrystalReportViewer1" runat="server" AutoDataBind="true" />

aspx.vb page

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)
        Dim Report As ReportDocument = New ReportDocument()
        Report.Load(Server.MapPath("~/CrystalReport.rpt"))
        Report.SetDatabaseLogon("sa", "######", "IT250WS", "demo")
        CrystalReportViewer1.ReportSource = Report
    End Sub

    Protected Sub btnPDF_Click(ByVal sender As Object, ByVal e As EventArgs)
        Dim Report As ReportDocument = New ReportDocument()
        Report.Load(Server.MapPath("~/CrystalReport.rpt"))
        Report.SetParameterValue("@EmpId", 1)
        Report.SetDatabaseLogon("sa", "######", "IT250WS", "demo")
        Response.Buffer = False
        Response.ClearContent()
        Response.ClearHeaders()
        Report.ExportToHttpResponse(ExportFormatType.PortableDocFormat, Response, True, "File_Name")
        Response.[End]()
    End Sub

Getting error :
Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))
Exception Details: System.Runtime.InteropServices.COMException: Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))

c#
asp.net
.net
vb.net
crystal-reports
asked on Stack Overflow Jan 22, 2020 by Rakesh • edited Jan 23, 2020 by Rakesh

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0