Dim mSql As String = "SELECT * FROM tblUserActive WHERE NOT memberID IN (SELECT memberID FROM tbUserInactive)" Dim da As SqlDataAdapter = New SqlDataAdapter(mSql, mdlConnection.cn) Dim ds As New DataSet da.Fill(ds) Dim rptDocument As New ReportDocument rptDocument.Load(Application.StartupPath & "\Reports\RepMember.rpt") rptDocument.SetDataSource(ds) Me.CrystalReportViewer1.ReportSource = rptDocument Me.CrystalReportViewer1.Refresh()
Dim mSql As String = "SELECT * FROM tblUserActive WHERE memberID NOT IN (SELECT memberID FROM tbUserInactive)"
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)