About Windows file share delivery for a data-driven subscription

A SSRS subscription has two delivery options (Windows File Share and Email).  We would like to limit users to only Email delivery, to avoid windows password expiration on the File Share.

Is there a way to remove Windows File Share as an Delivery option, so Email is the only option?

Thanks.

John

 

 

 

Hello, I'm looking for the simplest way to automate sending SSRS reports to a Sharepoint document directory.  I know a document library is not a real directory but I am able to run copy scripts into one using the virtual path thats shown when I do Actions-> Open in Windows Explorer. However when I set up a subscription to send a report to this directory, I get an error: Failure writing file \\intranet\projects\docs\test.pdf : The network name cannot be found.  Just checking if anyone knows if this should be able to work or not. Thanks

I have a windows forms application ready now i need to transfer data from the windows forms to the web and to do this i need to write an HTML file that contains the form data, i mean the data contained in the form should be written to an HTML file to be submitted and this HTML file should be generated on the local PC. I have the code for the HTML file but how can i write this HTML file with the data values contained in my windows forms. Please give your suggestions. Best Regards, Syed

While I'm trying to read connection string which is in App.Config file I'm getting error like "Object reference not set to an instance of an object." string strconn = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"].ToString(); For the windows service where I need to keep app.config file and how to integrate that config file with the windows service exe file. Thanks in advance.

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

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.

 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?

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

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

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

Hi,

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

Hi 

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?

regards

Hari

Hi.

I need to save a subscription file share on this location:

\\Freja\Program Files (x86)\Logica\eBS-Connect\outbox

My problem is that I do not know how to write the path in UNC when there is spaces in the path.

Can anyone please help me?

BR Rasmus

Hi.

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

Hi.

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

Hi.

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

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