Member Avatar for 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

  • 1 Contributor
  • 1 Reply
  • 294 Views
  • 4 Days Discussion Span
  • Latest Post Latest Post by dimuthubas
Member Avatar for 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

CrystalReport.zip (4.84 KB)
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.