Hi, We have a data driven subscription report set up for one of our reports. The report has 3 different datasets that feed into it. Each dataset runs a different stored procedure. The report runs ok, but some of the data is missing from the report when run via subscription. If I run it manually, all the data is displayed. When running via subscription, it only appears to run one of the Stored Procedures from the 3 datasets. Any ideas anyone? Thanks
First blush, I'd say it's a security issue. The subscription is going to run under a different context than you do when you run the report manually. Monitor the servers where the report is running (server side trace if nothing else) and see which login is being used.