I've been asked to create a report that consolidates data from a number of database servers for a single view using Crystal.
I've used Crystal Reports for many years but mainly with Visual Studio and I'm used to automating tasks with code (For example, I would create the above report in code by populating a dataset with the data from each server and then passing the final dataset to the report).
I would like to know if I can create a report using Crystal that gathers data from multiple servers without having to program my way around it.
So my question is, can a Crystal Report collect data from a number of database servers to create a single view or, do I need to either code this up or, do I need to use something like a Crystal Reporting server?
Please let me know if you need more information - thank you