Reporting Services Data Driven Subscriptions with Multi Value Parameters
To send a parameterized report to a list of subscribers we can use the Data Driven Subscription. If the WHERE condition in the Report Dataset just contains single parameter values (something like: Select * From Sales where Department = 123) the setup is fairly simple. (There is already a documentation on how to achieve that:
Data Explorer and Power View to analyse Stock Market Insider Trades
Boardmembers of market-listed corporations are liable to publish their share transactions. You can lookup these announcements at msn.com-> http://investing.money.msn.com/investments/insider-transactions?symbol=MSFT Yet it was quite difficult to extract all the data directly from the website. Now with the new Data Explorer it just takes a few minutes to download all the information to excel and do exciting analysis. Here is an example: The following chart