How Can I pass a connection to Crystal Reports?

[LuizGustavo]

I´m looking for pass a connection to CR, but I can´t find a way, Someone to help?

 

[synapsevampire]

Pass it from where?

What version of Crystal?

What type of connection?

Don't be so secretive about your environment, we're all trustworthy here

-k

 

[LuizGustavo]

sorry, I don´t giv you some datails...

I know Crystal Reports opens your owns Connection with a DataBase, but what I really need to know is if I can open a connection with a DataBase like Oracle in VB and pass it to myreport.rpt, did you get it?

Version, Crystal Reports 8.0

What type of connection? Any type, since it been with a Database!

Don't be so secretive about your environment, we're all trustworthy here

sorry again, this is not useful to me!

 

[synapsevampire]

Here's an interesting thread on the topic:

http://www.experts-exchange.com/Databases/Crystal_Reports/Q_20503777.html

-k

 

[LuizGustavo]

I think you didn´t get it!!

I´ve just seen this topic, I´m looking for my question for 5 days in the internet, actually I think I took a look over whole internet.

What I wanna know is to pass a database connection (already open) to myreport.rpt.

I really think this doesn´t have a solution, but I will look one more day in the internet and after that I will open a case with Seagate Crystal Reports.

thanks,

Luiz Gustavo!

 

[craigber]

What type of connection? ADO, RDO, ODBC? Something else?

Craig Berntson
MCSD, Visual FoxPro MVP,

http://www.craigberntson.com

Author, CrysDev: A Developer's Guide to Integrating Crystal Reports"

 

[LuizGustavo]

ADO Connection!

I believe there´s no solution to the way I would like to solve this problem!

now, I´m studying to do a report using ttx, and pass a Recordset to it, and I found another question, that to me is more important, I´m looking for documentation about SetPrivateData, I would like to know if when I pass a Recordset to my myreport.rpt the Crystal Reports just point to the memory area where my recordset is, or it copy de memory?

thanks!

 

[craigber]

There are two ways you can work with ADO. Crystal Reports can query the data and get back an ADO record set or you can generate the ADO yourself and pass the record set to the RDC. There is a Crystal Reports article on my web site that may help you and examples of both methods in my book.

Craig Berntson
MCSD, Visual FoxPro MVP,

http://www.craigberntson.com

Author, CrysDev: A Developer's Guide to Integrating Crystal Reports"

 

[LuizGustavo]

Give me the name of the article, please!

thanks!

Luiz Gustavo

 

[craigber]

There aren't that many. It's easy to find, but here's there direct link:

http://www.craigberntson.com/Articles/kb014.htm

Craig Berntson
MCSD, Visual FoxPro MVP,

http://www.craigberntson.com

Author, CrysDev: A Developer's Guide to Integrating Crystal Reports"