different instances of a same database(Urgent)
I need help.......
I am trying to create a report whose datasource will be different instances of the same database.So both the databases contains the same tables with same schema but the thing is that teh data is different.I have to collect the daat from different instances of the same table a(as they contains different different data) and using the collection to generate the report.
It's very very urgent ...plz reply ...
Thanx in advance