Generating a MS Access Report from a User Defined Array

[seenoorao]

Hi,

I have an array which is created by a function in my .Adp file.
I need to generate a ms access report based on this Array.
How can I achieve this?

Tia.

 

[jrbarnett]

You need to write the contents of the array to a table then base the report on the table.

John

 

[Remou]

Hi
Would it be possible to build a report on-the-fly, or use a 'blank' report with a series of text boxes that could be filled in using the Detail On Format event? I tried this, and it seemed to work.

[tt]'Module:
Public MyArray(0, 1)

Sub ArrayReport()
MyArray(0, 0) = "Hello"
MyArray(0, 1) = "World"

DoCmd.OpenReport "rptArray", acViewPreview
End Sub
'=================
'Report:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.Text0 = MyArray(0, 0)
Me.Text2 = MyArray(0, 1)
End Sub[/tt]