> If anybody know anything about Stored Proc and using SQL Server 2000,
CR8.5
> and VB6.0

> How to set Stored Proc name using RDC and the database is SQL server
instead
> of Access file.
> The below example show to set the table name using access database to rdc.

> Thanks
> ------------------------------------------------------
> example
> ------------------------------------------------------
> Public Sub AddDatabase()
> 'Variables used to setup the Database connection
>      Dim crDBTables As CRAXDRT.DatabaseTables
>      Dim sDatabasePath As String
>      Dim sTableName As String

> 'Get the Tables collection because it has the Add() method needed
>   'to add a connection to the report
>        Set crDBTables = crReport.Database.Tables

> 'Set the values for the connection variables
> 'The full path and name of the Access database.
> 'The database resides in the same directory as the application
>        sDatabasePath = App.Path & "\xtreme.mdb"

>   'The name of the Access table
>        sTableName = "Customer"

> 'Use the .Add() method to add the database table to the report.
>   'There are several optional arguments for the Add method. Which
arguments
> are passed
>   'will depend on the type of database, the type of table and the type of
> connection.

> 'Add the 'Customer' table
>        crDBTables.Add sDatabasePath, sTableName
> End Sub
> -----------------------------------------------------------