How can I pass values to Crystal 9 “Formulas� and “Selection Formula� with VB6

[dimuthubas]

Hi..

I have done some programs in VB6 (SQL Database). With the Crystal report (Vertion 4).

Now I wanted to do these things with Crystal-9. But the procedure to pass values to “Formulas and “Selection Formula is different and I can not get it done.

So pls can u give me a small sample code for it. I’ll show u a sample how I have get it done in Crystal-4.

Ex.
This is how i have pass values to “Formulas

CrystalReport1.Formulas(0) = "PAWBNo='" & Trim(Text11.Text) & "'"
CrystalReport1.Formulas(1) = "AWB_Pcs_Wgt='" & Trim(Text13.Text) & "'"
CrystalReport1.Formulas(2) = "CoName='" & Trim(Text6.Text) & "'"

This is how i have pass values to “Selection Formulas :-

CrystalReport1.SelectionFormula = "{PF_DOrder.SerNo} = '" + Trim(Text17.Text) + "'"
CrystalReport1.Action = 2 'Display

pls. write to me...i'm runing out of time..

Appreciate u’r help..

Bassa

[dimuthubas]

Hi….

I have attached a very simple code to show u how I have tried this with Crystal 8. . I was able to find the solution for “Selection formula.

But Still I couldn’t find a way to pass a value Normal “Formula. Can somebody c what the :?: here is…???

Thanking u
Bassa