Visual Basic Crystal Reports - Item in FormulaFields is empty

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Item in FormulaFields is empty

stefan@gacner.de

2006-04-11, 8:10 am

Hi,

I want to open a Crystal-Report, calculate some values (in the report)
an read them via VB.

I use the code:

Set crystal1 = New CRAXDRT.Application
Set Report1 = crystal1.OpenReport("xxxxxx.rpt")

For n = 1 To Report1.Database.Tables.Count
Report1.Database.Tables(n).SetLogOnInfo "db", "", "user", "pw"
Next n

Set offds = Report1.FormulaFields
For i = 1 To offds.Count
Set offd = offds(i)
Debug.Print i, offd.Name, offd.Value,offd.text
Next

I get the 'Name' and the 'Text', but the 'Value' (want I realy want) is
always empty.

What can I do ???

Thanks !!

Servus, Stefan.

Sponsored Links