tables from two servers

[gagani]

I want to add tables in two different servers. Could anyone please let me know how to add second server so that the tables of it can be linked with the tables of first server.

 

[RTag]

what is your database type ?

http://www.R-Tag.com

Viewer, scheduler and report manager for Crystal reports and SSRS.
Send your report everywhere.

 

[gagani]

sql

 

[RTag]

You can use linked servers or OPENROWSET. Check this article:

http://www.techrepublic.com/blog/da...ign-data-using-sql-servers-linked-servers/133

http://www.R-Tag.com

Viewer, scheduler and report manager for Crystal reports and SSRS.
Send your report everywhere.

 

[gagani]

How do I implement in crystal report?
I am trying to join two tables of different servers in crystal report.

 

[Madawc]

You ought to be able to add tables from two different databases, including those on different servers. I've done it occasionally, as well as linking a database to a text file or Excel spreadsheet.

A problem might arrise making links betwee the two. If you can't make a direct link, you could put one of the tables in a detail-level subreport and pass a parameter. Inefficient, but it is an option.

Another possibility is writing your own SQL and putting it into Crsytal as an SQL Command.

PS. This is based on Crystal 11. It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[RTag]

The best way is to create a stored procedure and to base the report on it.If you don't have rights to do this , as Madawc proposed, you can create a command in crystal reports.

http://www.R-Tag.com

Viewer, scheduler and report manager for Crystal reports and SSRS.
Send your report everywhere.