Printing With Crystal ( using VB6

Hi Guys

I have a problem.I have to select some records in VB6 using formulas to pass them value to Crystal Reports 9 but I don't know why.

Have you got a an example to show me.

In VB6 with CR7 i usually do this way.

strFormula = ""
strFormula = " {PROCESSOS.PROC_STATUSPAG}=" & 0
strFormula = strFormula & " AND {PROCESSOS.STATUS_ID} <>" & 9
strFormula = strFormula & " AND {PROCESSOS.PROC_INVNUM}='" & "" & "'"

Form.crystal.ReplaceSelectionFormula strFormula

FrmPrincipal.CstRelatorio.Connect = "DSN=3RD;uid=" & strUsuario & ";pwd=" & strSenha & ";dsq=" & strBanco

FrmPrincipal.CstRelatorio.Action = 1


I dont't know how to do this using VB6 with CR9.

Can you help me please?

welcome to The Forums. :wave: I believe you are in wrong forum.
Cant you simply make a query from vb and pass it to CR9 SQLqueryString?

Moved From FAQ Section