VB.net with SAP Crystal Report

[Former Member]

Hello All,

can anyone help me out with this issue on crystal report:

CR version 13.0.20.2399

Visual Studio Ultimate

When i try to move from the first page onto the second page, am getting this prompt,

'The report you requested requires further information'

Below is my codebehind

    myRrpt.Load(Server.MapPath("~\Reporting\CrystalReport15.rpt"))

        connect_EWS.ConnectionString = Constr_EWS
        Dim con As New SqlCommand
        Dim query As String = "SELECT * from Report_BT where Number=@num"
        con.CommandText = query
        con.Connection = connect_EWS
        con.Parameters.AddWithValue("@num", txtNumber.Text.Trim)
        connect_EWS.Open()
        '  Dim dsCustomers As New ISAE_BankTransfer
        Dim da As New SqlDataAdapter(con)

        Dim dsCustomers As DataSet4 = New DataSet4
       
        da.Fill(dsCustomers, "Report_BT")
        connect_EWS.Close()

        myRrpt.SetDataSource(dsCustomers.Tables(0))
        CrystalReportViewer1.DisplayPage = True

        CrystalReportViewer1.ReportSource = myRrpt

can someone help me out.

The website is published internally on Windows Server 2012 DataCenter

Thanks in advance

[former_member11696 · Accepted solution]

You need to use Sessions and PostBack to keep the report in scope.

Search for this KBA for example code:

1985571 - How to use sessions in web applications using the Crystal Reports viewer (the complete code)

Don