passing formulafield from vb6 to CR9

[Periko]

Hello,

I try to pass a formulafield from my vb6-application to my CR9-report. Problem is, i can pass the field like
report.formulafields(0).text = chr(39) & "my test" & chr(39)

However, the formulafield's name on the report is called test
so, this next sample isn't recognized by CR9 :
report.formulafields(0).text = "test =" & chr(39) & "my test" & chr(39)

Can anybody help me ?

Greetings...
Pedro from Belgium

 

[vidru]

Try it like this:

report.FormulaFields.GetItemByName("test").Text = Chr(39) & "This is my test" & Chr(39)

-dave

 

[Periko]

Thx vidru,

that did it !

this was a very useful tip !