question

KazHeath avatar image
KazHeath asked

Data Driven Reports - Report Manager

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
reportingsubscriptions
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
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.
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KazHeath avatar image KazHeath commented ·
Thanks for this - I have already checked this though and it seens to be fine. All logins and password are set up the same for each of the 3 datasets and the datasource too. Very frustrating!
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.