Array as datasource for a report

[Gerry Abbott]

Hi All,

I have a three dimensional array holding data generated from manipulation of
a recordset. This is done in a form, but could be done in the report at
start up.

Is there a way I can use this data to populate the report.

I want to avoid throwing it into a table, and using this for the report, but
that's an option.
Any advice welcome.

Gerry Abbott

[rkc]

"Gerry Abbott" <pl****@ask.ie> wrote in message
news:dE******************@news.indigo.ie...

Hi All,

I have a three dimensional array holding data generated from manipulation of a recordset. This is done in a form, but could be done in the report at
start up.

Is there a way I can use this data to populate the report.

I want to avoid throwing it into a table, and using this for the report, but that's an option.
Any advice welcome.

No advice, just a Google url for a post from Keri Hardwick that
you may be able to use.

http://groups.google.com/groups?oi=d...m=an_517538175

[DFS]

"Gerry Abbott" <pl****@ask.ie> wrote in message
news:dE******************@news.indigo.ie...

Hi All,

I have a three dimensional array holding data generated from manipulation of a recordset. This is done in a form, but could be done in the report at
start up.

Is there a way I can use this data to populate the report.

I want to avoid throwing it into a table, and using this for the report, but that's an option.

Depending on how many records you have, you could add an unbound text box to
the report for each field and record, then populate them with code on the
report open.

It will almost certainly be easier and cleaner to write the data to a temp
table and base the report on that.

Any advice welcome.

Gerry Abbott

[Gerry Abbott]

Thanks for that

In the absence of any other advice,
I think ill have create a table to hold the data.
then empty the table before population it with the data.
Then run the report using the table as the record source.

Sounds like a long way around what should be simple problem

Gerry
"rkc" <rk*@yabba.dabba.do.rochester.rr.bomb> wrote in message
news:ZK********************@twister.nyroc.rr.com.. .

"Gerry Abbott" <pl****@ask.ie> wrote in message
news:dE******************@news.indigo.ie...

Hi All,

I have a three dimensional array holding data generated from

manipulation of

a recordset. This is done in a form, but could be done in the report at
start up.

Is there a way I can use this data to populate the report.

I want to avoid throwing it into a table, and using this for the report,

but

that's an option.
Any advice welcome.

No advice, just a Google url for a post from Keri Hardwick that
you may be able to use.

http://groups.google.com/groups?oi=d...m=an_517538175

[Gerry Abbott]

Thanks
Emptying table and writing to it each time turned out to be easy.

Your suggestion probably would have worked, as there is a constant number of
fields, 36.

Gerry

"DFS" <no******@nospam.com> wrote in message
news:vs************@corp.supernews.com...

"Gerry Abbott" <pl****@ask.ie> wrote in message
news:dE******************@news.indigo.ie...

Hi All,

I have a three dimensional array holding data generated from

manipulation of

a recordset. This is done in a form, but could be done in the report at
start up.

Is there a way I can use this data to populate the report.

I want to avoid throwing it into a table, and using this for the report, but

that's an option.

Depending on how many records you have, you could add an unbound text box

to the report for each field and record, then populate them with code on the
report open.

It will almost certainly be easier and cleaner to write the data to a temp
table and base the report on that.

Any advice welcome.

Gerry Abbott