How to pass recordset to CR in VB

[LAYZ]

Hi,
I am relatively new to VB and Crystal reports.
Please, help me with some working sample or reference book I can
read to
retrieve data into adodb recordset and pass it to the pre-formatted
Crystal report.

Thanks

 

[Hexonx]

I had execellent success using disconnected ADO 2.6 Recordset objects. That is, until the reports needed to be run over Citrix. My stored proc reports worked, but the TTX reports all threw "Physical Database Not Found" error because the data driver would not load (although it was installed).

Here's how:

http://support.crystaldecisions.com/library/kbase/articles/c2004983.asp

If you get it to work over Citrix, let me know.

 

[LAYZ]

Thank you for the tip but in my VB program I am using DB2 database for data query.
That's why I would prefer just to retrieve data from tables using user's selection criteria and pass it to CR.

Thank you any way.

 

[kenhamady]

Crystal doesn't have good documentation on this, IMHO. There are several reference books that cover this topic, including my own. You might also want to try the book by Peck, "The Complete Reference".

The short answer is that you have to create the report using the active data driver, and then use the SetPrivateData command to pass the recordset to the report. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[LAYZ]

Thank you Ken.
I've looked up Peck's book V8 and I will probably get yours too.
Does your book cover data access security, I mean, does it explain how to pass userid and password at run time in order to retrieve data from DB2?

 

[LAYZ]

Thank you Ken.
I've looked up Peck's book V8 and I will probably get yours too.
Does your book cover data access security, I mean, does it explain how to pass userid and password at run time in order to retrieve data from DB2?

 

[kenhamady]

If it is via ODBC the Logon syntax should be the same as any other ODBC..so I believe yes. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[LAYZ]

Hi Ken,
Lately, when I tried to follow some Peck's instructions I realize that there is something wrong with Crystal Reports on my PC. I don't know whether it is my mistakes or installation is not complete.
I am trying to add RDC to my project. The book says that from the components designers tab I should select Crystal Reports 8 and then Add Crystal Reports 8 from project pull-down menu. What I see is Crystal Report 7 stuff but at the same time, I can find libraries for CR8 in project references.
To have Crystal reports 8 I used upgrade disc v8 over previously installed v7.
What (or who) do you think is wrong?

 

[kenhamady]

Upgrades can be flaky about that kind of stuff, but I did 7 to 8 to 8.5 and mine behaved just like it was supposed to. You want to make sure that all of the V8 dlls got installed. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[LAYZ]

How can I check what is missing?

 

[balves]

What version of Crystal V8 did you buy?

Professional or Developer?

 

[LAYZ]

I believe, that was upgrade for v8.1, but never mind....
I am going to install v8 from the scratch.
Thanks a lot for your time. I will be back to get your book.

 

[vlad2]

Can anybody send code?