Hello world, first post here!
Plan to evaluate Crystal Report Server. Before evaluation, want to know if the product works well with multiple DBs with same name and schema.
Basically, there is an application installed on multiple sites. As it's the same application, default database name, login credentials, schema, are all the same.
My goal is to retrieve data from multiple databases, and present the data in one report. So the report will need to have multiple database connectors.
If the goal is only to generate a report, and no need for scheduled report/live office, etc, will Crystal Report alone can do the job?
Thanks.