Data Driven Subscriptions in a report that has a subreport
Hi,
I'm trying to set up a data driven subscription on a report that I've created that has two subreports. If I try to set up the subscrpition on the main report, I receive a message notifying me that a subscription cannot be created because the credentials
are not stored within the report. If I think about it, this makes sense, since the parameters from the main report are being passed to the subreport, so now for my question: Aside from creating the report in a way that doesn't use the subreports,
is there a way to get data driven subscriptions to work with a report that has one or more subreports? Setting a data driven subscription up on the subreports works fine, as nothing is being passed to another report.
Before I forget, the main report and subreports are using a shared data source with its own unique user specified in the credentials.
Thanks,
Pablo
July 2nd, 2011 10:03am
Are you using expressions such as user!userid in the report?
Free Windows Admin Tool Kit Click here and download it now
July 2nd, 2011 11:38am
Thanks for your reply Shahfaisal.
Yes, user!userid was in the report and was causing the warning message. By removing user!userid I'm now able to setup a data driven subscription.
July 2nd, 2011 11:49am