Connecting to data on a different Server in CR 8.5

[rahulroy08]

Hi

I'm using CR 8.5 and need to connect to a SQL Server Database on another server. Is it possible? If yes then how can I do it ?


Rahul.

 

[Madawc]

Do you mean, change the database for an existing report? Use Database > Set Location

If you're trying to integrate data from two different databases, this can be done using subreports. Inefficient but sometimes unavoidable.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[almaragni]

YOu should be able to ... ADD DATABASE and then select a new connection and database table.