I have a report that uses 3 different datasets to populate different parts of the RDL file. All datasets are set up to use the same credentials. The report is usually run via the Data Driven Subscriptions.
When you run the report manually for an individual site, all data on the report is populated and the report exports to PDF as expected. However, when you run the report via the subscription in report Manager, only part of the data is actually populated.
Looking more closely, it only seems to be running one of the datasets.
I don't think this is a permissions or security issue as if it was, no data would be returned at all.
Any ideas please?
View Complete Post