Passing Input from Vb to Crystal Formula, Help pls.

[papaboy2]

i have a vb application using crystal report viewer, and i want to pass a parameter to my crystal reports 8.5 built report, but i get a "subscript out of range error" my code looks like this..my formula name is @MyString so when i insert it in the report theres a double "@" sign. thank you very much. help/



Dim lApplication As CRAXDRT.Application
Dim lReport As CRAXDRT.Report

Dim strselection As String


Private Sub Form_Load()

Set lApplication = New CRAXDDRT.Application
Set lReport = lApplication.OpenReport("C:\MYPROJECTS\FUND MANAGEMENT SYSTEM\REPORTS\DIVIDEND PAYMENT.RPT", 1)

lReport.FormulaFields(0) = "@@MyString = 'Sample'"

CRViewer1.ReportSource = lReport
CRViewer1.ViewReport
End Sub

 

[GJParker]

Crystal Collection Indexes start at 1 not 0, so your codfe should be

lReport.FormulaFields(1) = "@@MyString = 'Sample'"

However your question states you are trying to passa a value to a paramter and not a formula field, syntax for a parameter would be

iReport.Parameter(1).Value = 'Sample'

HTH

Gary Parker
MIS Data Analyst
Manchester, England

 

[papaboy2]

i tried using this code:

lReport.FormulaFields(1) = "@@MyString = 'Sample'"

but it says "object doesn't support this method or property."

im sorry for the mistake, but im trying to pass a value to a formula named "@MyString"

thank you very much again. i appreciate ur help.

 

[vidru]

I responded to your thread in the VB forum (thread222-852306).

-dave