Very Computer

Subject: Crystal Report 4.5 Stored Procedure
Newsgroups: comp.lang.basic.visual.database
Organization: Hong Kong Supernet
Summary: Problem in Crystal Report 4.5 Stored Procedure
Keywords:

I have problem of using Stored Procedure in Crystal Report V4.5.
The problem was in design time I defined database A for the stored
procedure. But in run time the store procedure was still connect database
"A" even though I specified the different database location at database
"B".

The syntax I used was:
CrystalReport.Connect="DSN=MyDSN;UID=Me;PWD=Me;DSQ=databaseB"
CrystalReport1.Datafiles(0)="databaseB.dbo.proc(MyStoredProc;1)"
CrystalReport1.Action=1

Can any one give me suggestion to solve this problem? Will Crystal
Report V5.0 solved this problem.

Eugene Chan

Not quite sure but try to do an 'Add database to report' in your RPT file
or alternatively do a 'Set Location' from the database menu. Then click on
set location PushButton, then do connect to database & select the ODBC dsn
you want to use & the stored procedure name from the other database. (both
SP name should be the same)
Save your rpt file, & try it from VB.

--
Frdric.

Quote:> Subject: Crystal Report 4.5 Stored Procedure
> Newsgroups: comp.lang.basic.visual.database
> Organization: Hong Kong Supernet
> Summary: Problem in Crystal Report 4.5 Stored Procedure
> Keywords:

> I have problem of using Stored Procedure in Crystal Report V4.5.
> The problem was in design time I defined database A for the stored
> procedure. But in run time the store procedure was still connect database
> "A" even though I specified the different database location at database
> "B".

> The syntax I used was:
> CrystalReport.Connect="DSN=MyDSN;UID=Me;PWD=Me;DSQ=databaseB"
> CrystalReport1.Datafiles(0)="databaseB.dbo.proc(MyStoredProc;1)"
> CrystalReport1.Action=1

> Can any one give me suggestion to solve this problem? Will Crystal
> Report V5.0 solved this problem.

> Eugene Chan