I have a report which pulls data from different database and servers based on date parameters. For instance Server1 and Table1 has the most recent data for the past 3 months and Server2 and Table1 has the archived data, so if a user is issuing the startdate
& enddate within the recent 3 months it has to use the datasource1 else datasource2 based on the date parameters. How do we do this in SSRS?
View Complete Post