Need help Crystal Report doesnt filter URGENT!
Hi, can anyone help me here..
My problem for almost one month..
I have two tables in Access database...
1.) FinalCustRSO
Fields:
RSONO PK Autnumber
Customer text
ZeroStock text
NewProduct text
ProjectForecast text
WithMotherPO text
Others text
RequestedBy text
NotedBy text
ReceivedBy
2.) FinalItemRSO
Fields:
DataID
RSONO
ItemCode
ItemDescription
Source
MOQ
QuantityRequired
Remarks
now, i create a query Called "FinalCustItemRSO " which is the combination of the two tables above (one - Many Relationship (FinalCustRSO - FinalItemRSO). and i used that query to make selection easier. but the problem is that it doesn't Filter the data displayedinmy crystal report based on the code inside the Getrecords below.. but i though that i got right codes.
my question is why it doesn't work?
can you please help me how could my crystal report work good...
Here nis my code below...
Private sub_Formload_click
Dim newRep As New LunisCryatal
GetRecords()
newRep.SetDataSource(ds)
newRep.Refresh()
CrystalReportViewer1.RefreshReport()
End sub
Private Sub GetRecords()
ds.Clear()
ds = New DataSet
Dim cmd As New OleDbCommand
cmd.Connection = cn
cmd.CommandType = CommandType.Text
cmd.CommandText = "Select * from FinalCustItemRSO where RSONO=" & Me.cboPrintRsoNo.Text & ""
da.SelectCommand = cmd
RSONO=" & myRsonotoprint & "", cn)
da.Fill(ds, "FinalCustItemRSO")
End Sub
I really need help, your responce really appreciate, Please?

