Refrencing 2 Server table from a sp for Crystal Report?

goodmorningsky
01-14-2004, 12:28 PM
Hi, all.
My Comp's Sales Crystal Report needs a stored procedure that have to reference more than 2 tables from different Server..
like following

FROM ReportSALES AS R LEFT OUTER JOIN SSS07.MyFASHION.dbo.MySTORES AS S
ON CONVERT(int, R.STOREID) = CONVERT(int, S.STORE_ID)
(ReportSALES : comes from PPP server and
I passed Login info to Crystal Report for PPP server)
Crystal Report generates err..
AS I think, it gives err.. since Crystal Report knows only One Server's login info..

Is it possible? If so, how can I do it?
it's urgent...help..

Thank you all...

MKoslof
01-14-2004, 03:00 PM
Post the code you are using. And what version of Crystal are you using 7, 8, 8.5, 9?

How are you logging onto your report. Are you using an OLE DB or ODBC connection? If you use multiple tables you need to reference the location of each table with the .connectionproperties or .setlogonInfo method.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum