Again - "Server has not yet been opened" - using RDC

[rdharmar]

I am trying to use the RDC for the first time. I have imported an existing .RPT file and added the report viewer to my VB project. The reference material I have been referring to states that:

"The report inside your VB application will use the same data source as the imported report did. These data sources are all provided by crystal Reports functionality, seperate from any database-connectivity features within VB"

When I originally compiled the Report, the database location is set to or table that it points to is a stored procedure.

Qn1. What code am I missing to view the report in the CRViewer1 control? I have been using the default code that comes along when I added the RDC.

Thanks

 

[dcusick]

You have to logon to the server where the stored procedure is located. You can do this in the following way..

Report.Database.Tables(1).SetLogOnInfo "ServerName", "DBName", "UserID", "Password"

Where Report is the report you're trying to view.

Hope this helps.

Doug

 

[rdharmar]

Thanks, I have made some progress but I am getting a "invalid cursor state" error message. Any ideas!
By the way I am working with SQL server.

 

[rdharmar]

Oops. I am sorry I did not pass the server and database name correctly, but after fixing this I get a error message "server has not yet been opened"

 

[hal9000p]

Basically don't use DSN's in any shape or form..they are too problematic, short of installing the full Crystal app on your client. What you need to do is use ADO recordsets to gather the data for your report. Go to the Crystal web site and download the following document:
Using Data Definition (TTX) files to pass an ADO recordset to a Crystal Report.
I'm sure other people know this factoid, but don't seem to want to share it as I've seen lot's of these posts...

Dave

 

[rdharmar]

Thanks.

http://support.crystaldecisions.com/kbase/c2002290.asp

I am sure this is going to help.

 

[rdharmar]

RDC - Tutorial

http://support.crystaldecisions.com/communityCS/TechnicalPapers/rdc_tutorial.pdf.asp

Connecting the RDC to a Data Source

http://support.crystaldecisions.com/communityCS/TechnicalPapers/cr_rdc_dbconnectivity.pdf

Data Definition Files to Pass an ADO Recordset to Crystal

http://support.crystaldecisions.com/communityCS/TechnicalPapers/scr8_ttxado.pdf.asp