.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

How managing programatically a data-driven subscription

Posted By:      Posted Date: October 26, 2010    Points: 0   Category :Sql Server


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

More Related Resource Links

Multivalued parameter & Data driven subscription for SSRS 2005

I need to create data driven subscription for our reports. Most our reports have multi valued parameters (7-12 parameters with at least 4-5 with multiple values)and need to be send to a users between the range of 25-200. So standard subscription is really not a choice.I have gone through most of the threads before. Question 1:Does any one have a solution for the SSRS 2005 regarding passing mutiple values for a parameter for the Data subscription table. If yes, could you please share the information. Question 2:I found some solutions using the SOAP API. Can any one explain that in detail- how we can do it ?Reference:http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/8ab615b4-1373-4258-bf49-c2843cfea8e9/http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=516735&SiteID=1 Question 3:Here is the other solution I found in one of the postsApparently passing in values like {A, B, C} only works when you configure the parameter values not to come from a dataset so that SSRS doesnt check for ValidValues.Reference: http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/b2c50aea-2032-4025-a155-306c00fcb856/Any commends about this solution?Thanks

Problem with date values in data-driven subscription reports

Hello together, I have a question in regards of data-driven subscription report. I already have an ad-hoc report in place which can be customized by date etc. I now want to run these reports with a subscription. My challenge is now that I don't know how I can pre-define the date. I basically want the start date of NOW() and the end date 7 days in the past. I was looking around but did not get any clue where and how I have to configure it the way it works. I found this thread but honestly do not understand it well... :( http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/fb48fd15-09dd-4f5f-a09f-d92bf304c1a2 Can someone help me out please? M.

For a Data-driven Subscription, If it Processes 20 but 2 error , how do i just run the ones that err

 I'm trying to figure out if there is a way to just run the errored out ones.  Sometimes I have up to 100 being processed and need to only rerun the ones that error out. Is there a way to do this? and how?

Data Driven Subscription problem - sub runs slowly, has 40 errors out of 300, but report server trac

I have two report servers and a single separate SQL Server 2008 server hosting the data source database and the report server catalogues. There is a data driven subscription that runs off a sproc that returns 300 rows with email addresses for this report to be emailed to. The report itself contains around 30 subreports each with its own sproc to retrieve data. As the report is executing there are long pauses between the times when emails are actually sent out, and the subscription status will finally end with something like "Done: 300 processed of 300 total; 40 errors." I am not sure how to go about troubleshooting this problem. Details: I kicked it off at (say) 2:00 PM. Within 3 minutes in the report server execution log I saw 300 entries. There were exactly 300 people who should receive reports, so the master report should have executed 300 times and sent out 300 emails. So this looked good in the execution log. But when I checked report manager's status page for the subscription it was listed as processing 50 out of 300... Then all activity stopped, about 15 minutes some more reports started emailing out, and now I see there are around 590 rows in the execution log and maybe 97 emails sent out... Then finally I get a grand total of 846 rows in the execution log and a grand total of 260 of 300 emails sent out with 40 errors so 260+40=300 exactly. The time betw

How to pass multi-value parameters to DDS (data driven subscription)?

Using RS2005, how should multivalue parameters be stored in a database field so that a data driven subscription can properly read and use them?  I have so far had no luck using syntax of: 1)  parm1, parm2 2)  parm1,parm2 Do single qutoes need to explicitly wrap the values?  Can you please provide an example and a SQL INSERT statement using parm1 and parm2 to demonstrate what to store in the database field?  Thanks!!

SSRS data driven subscription with varying schedule


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.

- Steve

Error for delivering a report via email by using the data-driven subscription



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

SSRS 2008 R2 data driven subscription failing



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 &[23563]. This value works when i execute the report from reportserver using url parameter adding the following at the end &PAR_ASM=%26[23563]. But the same doesn't work when i do it from the subscription.

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?



About data-driven subscription



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?

Any helps to me, please? Thanks

Creating a data-driven subscription from a SSIS pkg



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

About Windows file share delivery for a data-driven subscription



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 \\mymachine\mysharedfolder.

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

Calling different report parameters in a data-driven subscription


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

Business Intelligence professional

Reporting Services account for a data-driven subscription - SSRS 2005



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.

Data driven subscription not working with Multivalued parameterized reports



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.....


SSRS 2008 Data Driven Subscription Timeout Error



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?


Velocity: Build Better Data-Driven Apps With Distributed Caching


Microsoft Velocity exposes a unified, distributed memory cache for client application consumption. We show you how to add Velocity to your data-driven apps.

Aaron Dunnington

MSDN Magazine June 2009

.NET RIA Services: Building A Data-Driven Expense App with Silverlight 3


.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.

Jonathan Carter

MSDN Magazine May 2009

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend