Multiple Database in one report
Is there a way to create a dropdown list of database and then pick a certain database to have data pulled from that database? What I'm saying is that can we have 3 dataset in one report and use it as parameter. We have 3 database with same fieldname and table, just that it all have different data. Each database belongs to a segment of the company. At the meantime, the only workaround is to create different report for each department and have it point to a dataset.