Skip to Content
0

VB.net with SAP Crystal Report

Aug 30, 2017 at 04:05 PM

37

avatar image
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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Don Williams
Aug 30, 2017 at 04:09 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded