I've different databases configured. Consider as DB1 contains records from 2010-01-01 to 2010-12-31. DB2 contains records from 2011-01-01 to 2011-12-31. DB3 contains records from 2012-01-01 to 2012-12-31.
In UI having dropdown to select the any one of the database. Based on selection the respective DB will be hit to fetch the records and the result will be shown in SSRS report.
What I would like to do is that I want to get records from more than one databases at a time and show the report. Is is possible or achievable?
I know by joining more databases and make it as single DB it is possible. But I look for other opions because I'm not supposed to do that.
Please do suggest. Thanks in advance.