Hi everyone, I'm using VB 6.0, Crystal Reports 8.5 and the data is in an Access 2000 database.
I have a report already built and now I working on my parameter interface in vb. The details section of the report contains a running total, several database fields and a formula. All are visible. It is a pretty simple report. I am attempting to store all the fields (table and field name) in an array. I am struggling with the syntax.
Here is the approach I would expect to work:
Dim crpFIELD As CRAXDRT.FieldObject
I = 1
For Each crpFIELD In REPORT.Sections("D").ReportObjects
Set crpFIELD = REPORT.Sections("D").ReportObjects(I)
FIELDS_ARRAY(I) = crpFIELD.Name
I = I + 1
Next
When stepping through the code above, crpFIELD.NAME = "Field1", "Field2", ...
Any pointers or advice would be greatly appreciated.
Regards.
I have a report already built and now I working on my parameter interface in vb. The details section of the report contains a running total, several database fields and a formula. All are visible. It is a pretty simple report. I am attempting to store all the fields (table and field name) in an array. I am struggling with the syntax.
Here is the approach I would expect to work:
Dim crpFIELD As CRAXDRT.FieldObject
I = 1
For Each crpFIELD In REPORT.Sections("D").ReportObjects
Set crpFIELD = REPORT.Sections("D").ReportObjects(I)
FIELDS_ARRAY(I) = crpFIELD.Name
I = I + 1
Next
When stepping through the code above, crpFIELD.NAME = "Field1", "Field2", ...
Any pointers or advice would be greatly appreciated.
Regards.