I got a serios problem this time..

I need to create report each field in the report has different condition so,

when i write the select statement I can't put all conditions in one where clause because

it will check all of them together!!!!

I used select union all select but the only one works is the first one

any help plz


can u post some of your code so i can understand what are u requesting??? :)

B3_Select = "select Ba1"+ _
"from (B) where " + _
" Ba1<3.9 or Ba1 > 6.1" + _
" Union All " + _
"select " Ba2 " + _
"from B where " + _
" Ba2 < 2.9 and Ba2 > 9.4"

Dim da As OleDbDataAdapter = New OleDbDataAdapter(B3_Select, System.Configuration.ConfigurationManager.ConnectionStrings("ConnectionString").ToString())

Dim ds3 As New System.Data.DataSet

da.Fill(ds3, "B")

Dim MyReport As New CrystalDecisions.CrystalReports.Engine.ReportDocument


Me.CrystalReportViewer1.ReportSource = MyReport


This is my code... it takes the first select only!!!!!