Can i use an ADO recordset to open a Report with the OCX?

[raedwa01]

I created a report that is used to make "Meal Tickets" for my students. The number of meal tickets can be dynamic each time i run the report. The only solution i found to this is to use the OCX and pass .DetailCopies = n where n is the number of tickets i need.

The problem is, the report is using the Active Data DLL and when i use the command crOCX.DataSource = rs, I get an error 13 "Type Mismatch". I called Crystal about using thr CRAXDRT before, and guess what isn't in the CRAXDRT? That's right, DetailCopies. So, I can't seem to pass an ADO recordset to the OCX and i can't do multiple details in the CRAXDRT.

Please Help, did i do something wrong? All Crystal could do is send me some dumb lables report using some mysterious loop to do x number of labels. This didn't help much.

Rob

 

[kenhamady]

I beleive you can do this with SetPrivateData.
I will have to look up the syntax when I am back in my office tonight Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.