Why is it the query doesnt work

[psychofoo]

can u tell me how u display ur query in Crystal?

[pnish]

Up until very recently I used the Crystal API for reporting, but am now starting to use theCrystal RDC and the Report Viewer. I use 'Selection Formulas' rather than queries, similar to the following:

Option Explicit
 
Dim Report As New CrystalReport1
Dim crProp As CRAXDRT.ConnectionProperties
 
Private Sub Form_Load()
 
    Screen.MousePointer = vbHourglass
    
    Set crProp = Report.Database.Tables(1).ConnectionProperties
    crProp.Item("Database Name") = App.Path & "\mydb.mdb"
    crProp.Item("Database Password") = "mypassword"
    
    [color=red]Report.RecordSelectionFormula = "{mytable.myfield}='condition'"[/color]
    
    CRViewer91.ReportSource = Report
    CRViewer91.ViewReport
    Screen.MousePointer = vbDefault
 
End Sub

So I guess your query would look something like:

Report.RecordSelectionFormula = "{tCommission.contno} Like '%" & NContNo & "%'"