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

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