Passing Array from VB6 to CR9 Designer Report 2

[mrf3000]

Hello all,

I have a question I hope somebody can help me with. I have an array variable built upon some calculations done in VB6. I want to pass that array to a Crystal designer with TTX fields already defined. I can't find anything on how to do this in CR9, although I did see some code for CR 8.5 which doesnt work, because it calls the Crystal data Object which doesn't seem to exist in Cr9. If anybody has done this before I would be very appreciative if you could tell me how to do it.

Thanks,
Marc

 

[Jacque]

Hi Marc,
You might want to check out

http://www.crystalbook.com/crtcr/program/book/extras_9.asp

and see if any of the downloads are applicable for what you want to do.
Hope this helps,
Jacque

 

[vidru]

You could create a recordset from your array, then pass the recordset as the data source for the report.

-dave

 

[mrf3000]

Jacque and Vidru,

Thanks both for your advice. I ended up creating a recordset from the array and then passed that to the report. It was simple enough and I could kick myself for not thinking about it. Anyway, there is nothing I can find in Crystal 9 about passing an array to a report, and even though it was a bit convoluted in previous versions, it could be done. Boo hoo to Crystal for not having a feature by feature comparison of all its products considering how much things have changed from 8 now through 10. Thanks again.

Marc

 

[vidru]

I was looking at the available References in VB on my machine at home (which has never had a version of Crystal lower than 9.0), and noticed that the Crystal Data Object was available. I've never tried to use it, but from the lack of documentation about it, I'd suspect it's on their "deprecated" list.

-dave

 

[mrf3000]

Vidru,

I checked the crystal web site and knowledge base and there was nothing on the CDO from 9 or 10. I didn't have the reference in my VB reference list, but maybe it's something that's on the cd, and just isn't included as a default intstall. I'll take a look at that.

Thanks again,
Marc

 

[mrf3000]

There it was right on the cd as an option!!!
Oh well. I guess I learned something new today which is always a good thing.

Marc