Crystal Reports - Gathering data from multiple servers to consolidate to a single report
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
8/22/2022 - Mon
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!