0

Say I have parameter YearA and parameter YearB, both are a list of years (2016, 2014, 2014, etc.) BUT since they belong to different databases (and naturally) different datasets, I have 2 parameters scroll-down fields that appear whenever I run the report.

I would like to minimize the number of parameter fields that appear once the report is run. In other words, is there a way to either create a new parameter combining YearA and YearB? Like some sort of a Lookup function or something?

Thanks!

Bob
  • 467
  • 1
  • 4
  • 13
  • Are both databases in the same server? If so you could create a datasource with a login that has read permission over both databases, then just create a dataset that uses the previously created datasource and query the databases to get all years from both. – alejandro zuleta Aug 25 '16 at 16:14
  • Hi Alejandro, unfortunately, (to make things more complicated lol) they are from different servers. – Bob Aug 25 '16 at 17:09
  • In that case you could link both servers, check these links: [1](http://stackoverflow.com/a/1144070/2647648) and [2](https://msdn.microsoft.com/en-us/library/ff772782.aspx#Anchor_2) – alejandro zuleta Aug 25 '16 at 17:22
  • Thanks alot Alejandro! – Bob Aug 30 '16 at 15:13

1 Answers1

0

There is no option other than creating a linked server if the data sources are from different servers.

For more info: http://blogs.msdn.com/b/robertbruckner/archive/2008/08/07/dataset-execution-order.aspx

p2k
  • 2,126
  • 4
  • 23
  • 39