Visual Basic Crystal Reports

[yns]

I am opening a crystal report in Visual basic and I want to reference a formula in the crystal report from the visual basic. I also want to be able to reference a field in the crystal report, from the visual basic project.
Pls advise if anyone can help or if this is better off in the Crystal Reports forum

 

[Golom]

To see formula fields

Dim rdApp As CRAXDRT.Application
Dim rpt   As CRAXDRT.Report
Dim fla   As CRAXDRT.FormulaFieldDefinition

Set rdApp = CreateObject("CrystalRuntime.Application")
Set rpt   = rdApp.OpenReport("C:\myReports\TheReport.rpt")
[COLOR=black cyan]' Set the value for the 'Filter' field.[/color]
For Each fla In rpt.FormulaFields
   If fla.Name = "Filter1" Then
      fla.Text = "'" & myFilter & "'"
      Exit For
   End If
Next fla

I don't know of a way to reference a specific field but you could assign the field's value to a Formula field. My version of Crystal is somewhat behind the times (8.5) so there may be more functionality in later releases.

 

[yns]

Many thanks for your help. My colleague has overcome this problem.