Posted on: 5/26/2015 2:02:50 PM | Views : 665

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 ...