I used code below to export Crystal Report to pdf file. (displays on the screen).
It works fine for one OrderID like SQL statement below.
Dim sSQL As String = "select * from order where orderID=1234
Can someone help me to complete multiple OrderID like SQL statement below and display like one pdf document?
Dim sSQL As String = "select * from order where orderID in (1234,2356,8899)
------------------------------------------
Dim sSQL As String = "select * from order where orderID=1234
Dim Rpt As New ReportDocument
Dim ExpOptions As New ExportOptions
Dim MyCommand As New SqlCommand
Dim myDA As New SqlDataAdapter
Dim myDs As New DataSet
Rpt.SetDatabaseLogon("user", "password", "servername", "database")
myDs = GetSQLDataSet(sSQL)
myDs.EnforceConstraints = False
Rpt.Load("myreport")
Rpt.SetDataSource ...
Go to the complete details ...