Crystal Reports 8.5 SelectionFormula

[blakemckenna]

I am using CR 8.5 for reporting purposes. I am controlling the reporting thru VB6.0. My problem is that there is no "SelectionFormula" method to use.

Anyone have any ideas?

I have attached my code below:

Set oApp = New CRAXDRT.Application
    Set oReport = oApp.OpenReport(App.Path & "\Reports\Invoice.rpt", 1)
    CRViewer1.ReportSource = oReport
    CRViewer1. ?
    CRViewer1.ViewReport

What Method do I need to use to replace the question mark with?

Thanks,
Blake

[RobDog888]

The SelectionFormula is under the oReport report object.

[blakemckenna]

No wonder.....Thanks Rob!

[blakemckenna]

Rob,

I am using the "GroupSelectionFormula" method? If this is the correct method, I am receiving the following error msg "This field name is not known" on the following line of code:

oreport.groupSelectionFormula = strFormula

[RobDog888]

Edit: I didnt notice that you were not using an ADO rs as the reportsource. Would that be an option because it is easier sometimes to do all your grouping and sorting in the SQL string.