I need to create and edit a SSRS data-driven subscription inside a .NET application. Is it possible? Which objects or classer can I use?
Any helps to me, please? Thanks
View Complete Post
I've created a report hosted on SQL Server Reporting Services 2005. I know how to use the Reporting Services Web Services Class Library to create a timed subscription, so that a user can receive the report automatically every day.
Now I need to extend this to deliver the report to hundreds of users. That seems like an application for data driven subscriptions. I haven't worked with data driven subscriptions before. Here's what I'd like to know:
Within a single data driven subscription, can each recipient receive the report ON A DIFFERENT SCHEDULE? For example, user "A" wants to receive it every Tuesday at 9:00 AM, while user "B" wants it every day at 6:00 PM.
Thanks for your help.
I have created a SSRS 2005 report to export in the Excel format as a batch execution. I have made a data-driven subscription, I have specified the from mail address (with my address) and the smtp server in the RS configuration tool, I have set the SQL Server
Agent account with my domain user, but I have an error about the from address is refused from the server and the client was not authenticated. I have tried to specify the IP for the smtp server.
Any suggests to me in order to solve this issue, please? Many thanks
I have a SSRS report connecting to a SSAS cube. i have created a data driven subscription for two of the report parameters.
since its a ssas cube we have to pass the actual parameter value.
For ex: for parameter name PAR_ASM the value passed is &. This value works when i execute the report from reportserver using url parameter adding the following at the end &PAR_ASM=%26. But the same doesn't work when i do it from the
Also strange things is that this subscription was working on 2008, but after upgrading to 2008 R2 it started failing.
has anybody faced a similar issue?
I want to execute my SSRS 2005 report as a scheduled batch. I think to create a data-driven subscription and a table to pass the report parameters. In this table could contains more one records. So, when I specify the query or the command in the subscription,
the SELECT statement could reads more one records. I want that the behaviour the subrscription it to read all the records from the parameter table and execute the report each time for each record in the table. Is this the behaviour for the data-driven subscription
for a parameter table with more one record?
I would like to use a SSIS pkg to implement a data-driven subscription for a my SSRS 2005 report, by using the ReportingService2005.CreateSubscription Method. Is it possible? How? Is there a sample about this implementation?
Many thanks for your suggests
In order to try the data-driven subscription with the windows file share delivery, on my machine I have created a folder and then I have shared it adding my Windows account with full-control. The UNC of my shared folder is like
When the subscription starts I can see in the report server service log an error about the access to the shared folder on account or password isn't valid.
Now, how can I solve this issue, please? Do I change some settings in the config files of the report server? Many thanks
is it possible to change specific report parameters in a data-driven subscription on a per subscriber basis?
For instance I have a report with 3 parameters, when scheduling Joe I would like to select value A for parameter 1, User harry should have value B for parameter 2
I'm using sql server 2005 enterprise, when reading the MS data-driven subscription example I can only enter users and export format
I need to create a data-driven subscription that delivers a report to a shared folder. The Reporting Server service execution account is the LOCAL SYSTEM and so the subscription finishes with error. If the execution account is my Window login, the report
are saved correctly in the shared folder. Is it possible to specify LOCAL SYSTEM as the execution account for the Reporting Server service in order to implement a subscription or not? Can this execution account to be different respect to the user name to specify
in the data-driven subscription?
Many thanks for your suggest.
I am working with SQL server 2008 R2 , and creating a datadriven subscription with multivalues parameters. But its not working.
Report error Log is showing that "Default value or value provided for the report parameter 'category' is not a valid value.;"
I am passing the multivalue with comma separated value.
So, I want to know whether this works in 2008 or not.
Any kind of solutions you have, please welcome.....
I have a report that pulls data from an SSAS 2008 cube. The report does take a few minutes to run, as it is grabbing a lot of data. The report is published to our sharepoint website, with stored credentials. When I run this report manually
on the sharepoint site, it works fine. However, when I try to create a data driven subscription, it gives me the following error: Error: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
I've looked through the SSRS log file, and it basically just repeats this error. I've also run SQL Server profiler, and I can see that all of the queries that populate the parameters run successfully, but then there are no more queries sent. So,
it seems that the connection is fine, but the data driven subscription has another timeout value that is causing the problem. All of the datasets have a timeout = 0, so that is not the issue.
I've also run a different data driven subscription using a smaller report (based on the same cube though), and it works fine. Any thoughts on what I need to do to fix this?
Microsoft Velocity exposes a unified, distributed memory cache for client application consumption. We show you how to add Velocity to your data-driven apps.
MSDN Magazine June 2009
.NET RIA Services provides a set of server components and ASP.NET extensions such as authentication, roles, and profile management. We'll show you how they work.
MSDN Magazine May 2009