Crystal 9 with VB6, how?

[buddyready]

hi, i've just installed crystal report 9 and i'd like to try and use it with vb6?
I've created a database in Access.
Can u please help me in writing in VB6 to run my report in crystal9. How is this done? Are there any properties or methods and controls that i should be using.
Thanx alot for your help. Can u please show me a simple example.

[Ken Bradford]

There are a lot of examples here:

http://support.crystaldecisions.com/...s/apps_rdc.pdf

[vbnow]

Links:
1 - This document describes how to create a Visual Basic application using the Crystal Report Designer Component 9 (RDC). This document covers the basic properties and methods that would be used to create an application that prints, previews, or exports a report. This document is for use with Crystal Reports 9.

http://support.crystaldecisions.com/...torial.pdf.asp

2 - This document describes the new Report Designer Component properties and methods available at runtime to connect your report to its data source. This document is for use with Crystal Reports 9 and later.

http://support.crystaldecisions.com/...erties.pdf.asp

3 - This document describes the methods for creating a deployment package to distribute a Report Designer Component (RDC) 9 application. This document is for use with Crystal Reports 9.

http://support.crystaldecisions.com/...oyment.pdf.asp

4 - This file contains a help file for developers using the Report Designer Component (RDC). This utility allows you to navigate through the object hierarchy of the RDC using an 'Explorer tree' type interface. Included are descriptions and/or syntax of objects, collections, methods, and properties.

http://support.crystaldecisions.com/...rowser.exe.asp

------------------------------------------------------------------------------------

How to make a database connection using the Report Designer Component 9

The information in the article refers to:
Report Designer Component 9


Applies to:

Reported version only
Logon and RDC
ConnectionProperties



Synopsis

An application uses the Report Designer Component (RDC) 9 as the reporting development tool. Earlier versions of the Report Designer component used the 'SetLogonInfo' method to log on to the database in the main and subreport.

When using RDC in Crystal Reports 9, what is the recommended method to log on to a database?


Solution

When using the Report Designer Component (RDC), the recommended method to log on to a database in Crystal Reports 9 is the 'ConnectionProperties' method.

The 'ConnectionProperty' method has different properties depending on what type of connection you use in the report.

====================
NOTE:

To check what type of connection you are using:

1. In the Crystal Reports Designer, go to the Database > Set Datasource Location menu.
2. In the 'Current Data Source' dialog box, expand the 'Properties' node.

====================

For a native connection to an Access database, use the following code sample
----------------------------------------------------------------------------------------------

Dim crxDatabaseTable As CRAXDRT.DatabaseTable

For Each crxDatabaseTable In Report.Database.Tables
crxDatabaseTable.ConnectionProperties.Item("Database Name") = "C:\Temp\xtreme.mdb"
Next crxDatabaseTable

For an ODBC Connection, use the following code sample
--------------------------------------------------------------------

With External_Report.Database.Tables(1).ConnectionProperties
.Item("DSN") = "DSNname"
.Item("Database") = "DBName"
.Item("User ID") = "UID"
.Item("Password") = "PWD"
End With

For an OLE DB Connection, use the following code sample
----------------------------------------------------------------------

With Report.Database.Tables(1).ConnectionProperties
.Item("Provider") = "Provider Name"
.Item("Data source") = "Server Name"
.Item("Initial Catalog") = "Database Name"
.Item("User ID") = "UID"
.Item("Password") = "PWD"
End With


To set the path for an MDW file for an Access Secured Database using System Database Path
-----------------------------------------------------------------------------------------------------------------

Report.Database.Tables(1).ConnectionProperties.Item("Session UserID") = "vantech"
Report.Database.Tables(1).ConnectionProperties.Item("Session Password") = "vantech"
Report.Database.Tables(1).ConnectionProperties.Item("System Database Path") = "\\vanfps12\clo$\session level security\Secured.mdw"


====================
NOTE:

For further information about the 'ConnectionProperties' method go to http://support.crystaldecisions.com/docs and search for:

cr_rdc9_connectionproperties.pdf

====================

[buddyready]

thanx...alot..for the help...i still have to try it. thanx again.

[vbnow]

You're welcome!

[Sisyphus]

hey there .. I want to insert a Crystal Report Designer in VB.NET ...
In VB6 I've only got to click the Add Crystal Report 9 menu in the Project Menu. But I can't find one in VB.NET ... So, any idea??? how should I do it?