Scheduling Report Delivery to Printers

Hi,
Have any of you work with Extensions to schedule delivery of reports
directly to printers?
I played a little bit with the sample Delivery Extension provided by
Microsoft, I do not seem to get it to work.
Any ideas of how to schedule RS to print reports automatically?
ThanksThis is something I spent a lot of time on about a year ago without any
success.
The MS extensions I tried would almost work but it scaled the report just a
touch wrong and cut off text so it was of no use to me.
I would be very interested in solution myself.
"Jaraba" <Jaraba@.discussions.microsoft.com> wrote in message
news:E6E07910-4272-49C3-A3E9-86D6923B438B@.microsoft.com...
> Hi,
> Have any of you work with Extensions to schedule delivery of reports
> directly to printers?
> I played a little bit with the sample Delivery Extension provided by
> Microsoft, I do not seem to get it to work.
> Any ideas of how to schedule RS to print reports automatically?
> Thanks
>

scheduling delivery

i would like to ask how to execute the email delivery setting? can it be done
in the report server homepage'it is a must to get it work through web
service programming?
thanks in advanceIts form the report MANAGER home page http://servername/reports. Go to
whtever report you want the set the subscription on, and when you view the
report, you have a tab saying new subscription, click on tht and give the
parameter info and the schedule info.
"Jasonymk" wrote:
> i would like to ask how to execute the email delivery setting? can it be done
> in the report server homepage'it is a must to get it work through web
> service programming?
> thanks in advancesql

Schedule report delivery for all parameters

Is it possible to schedule the delivery of a report (to a file share
say) for each possible value of a parameter?
So, if I have a report that accepts a value for parameter @.color and
shows the corresponding tshirts in that color, and there are 3 possible
values for @.color (red, green, blue), can I somehow schedule the report
to automatically run for each value (resulting in 3 delivered reports)?
Thanks!You want to look into DataDriven Subscriptions. These allow you to execute
a query and use the results to drive subscriptions.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jim" <emailjeffp@.yahoo.com> wrote in message
news:1108132927.922517.3740@.l41g2000cwc.googlegroups.com...
> Is it possible to schedule the delivery of a report (to a file share
> say) for each possible value of a parameter?
> So, if I have a report that accepts a value for parameter @.color and
> shows the corresponding tshirts in that color, and there are 3 possible
> values for @.color (red, green, blue), can I somehow schedule the report
> to automatically run for each value (resulting in 3 delivered reports)?
> Thanks!
>

Schedule and Delivery Processor errors

Hi all,

We're running into some random errors on our reporting server (Windows Server 2003, SQL Server 2000 Enterprise). In the application logs, we're seeing several Schedule and Delivery Processor errors (ID 108)...one for each processing extension (FileShare, Excel, HTML, etc.). In the security logs, at the same time of day, are several failure audits with the following info:

EventID: 680
User: NT AUTHORITY\SYSTEM
Description: Logon attempt by: MICROSOFT_AUTHENTICATION_PACKAGE_V1_0. Logon account: sqluser.

The odd thing is that the schedules that are failing run perfectly about 98% of the time. Once every few weeks we have a situation like this and all of our reports (approximately 200 of them...mostly Excel, all of them sent via E-Mail) fail.

Any ideas as to what might be causing this, and why it would only happen occasionally? Any help would be appreciated! Thanks!

-Brian
http://searchwindowssecurity.techtarget.com/expert/KnowledgebaseAnswer/0,289625,sid45_gci1007131_tax299886,00.html?bucket=ETA&topic=299886|||Thanks Greg, however this link seems to relate to making sure the ASP.NET account has the appropriate permissions on both the web server and the database. In my situation, the account (sqluser) has the correct permissions for the database. The database and report server/IIS are both on the same box if that matters.

In fact, and this is what is really confusing me, everything works just fine for weeks on end...then without warning I start getting these errors and the jobs fail. Same account, same reports, same schedules, same recipients...nothing has changed, yet something has caused these errors. Any other thoughts?
|||

Do you think it could be a DOS attack?

Is it happening the same day of the week? Same time of day?

How many "accounts" are accessing the server? Some versions of SQL have a max amount of connections before it denies access.

Schedule and Delivery Processor Error

I am having issues with getting our Development Report Services Server to
schedule any reports to run. Recently, I had to change our service account
to a non-expiring one and now I get the following in our Event Log.
Schedule and Delivery Processor
Failed to decrypt symmetric key. Most likely cause is the serivce username
has changed.
Our setup is as follows:
W2K3 Web Server (running Reporting Services) and a seperate SQL 2000
Enterprise Server housing the Reporting Services database. I have run the
rsconfig and the rsactivate after changing the service account which
completed successfully.
Does anyone have any suggestions, short of totally reinstalling, to get this
error corrected and the scheduler working?
Thanks,
Greg QuinnI answered my own question. By running the rskeymgmt utility with the -d
flag I was able to delete all encrypted information from the reporting
services database and then ran the rsactivate and then reapplied the
datasources, parameters and schedules. Now everything appears to be working
correctly.
"Gregory C. Quinn, Jr." <gquinn@.yadtel.net> wrote in message
news:11vpjatmrfu45d2@.corp.supernews.com...
>I am having issues with getting our Development Report Services Server to
>schedule any reports to run. Recently, I had to change our service account
>to a non-expiring one and now I get the following in our Event Log.
> Schedule and Delivery Processor
> Failed to decrypt symmetric key. Most likely cause is the serivce username
> has changed.
> Our setup is as follows:
> W2K3 Web Server (running Reporting Services) and a seperate SQL 2000
> Enterprise Server housing the Reporting Services database. I have run the
> rsconfig and the rsactivate after changing the service account which
> completed successfully.
> Does anyone have any suggestions, short of totally reinstalling, to get
> this error corrected and the scheduler working?
> Thanks,
> Greg Quinn
>

Schedule and Delivery processor cannot connect

Hello,
I'm getting the following error on the application log of the event viewer:
Schedule and Delivery processor cannot connect to the report server database.
However I have no trouble to test some reports (e.g. the sample reports provided with reporting services).
What could be wrong with my configuration?
Thanks
CesarCan you look in the reportserverservice<date>.log files for more
information.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Cesar" <Cesar@.discussions.microsoft.com> wrote in message
news:BAF05421-386E-4712-8503-A304A1626C24@.microsoft.com...
> Hello,
> I'm getting the following error on the application log of the event
viewer:
> Schedule and Delivery processor cannot connect to the report server
database.
> However I have no trouble to test some reports (e.g. the sample reports
provided with reporting services).
> What could be wrong with my configuration?
> Thanks
> Cesar|||Hello daniel,
On one line of the log says:
"Cannot open database requested in login 'Report Server'. Login fails"
How can I fix that ?
But I had no errors during set up when I configured the account with which reporting services would use to connect to the database.
"Daniel Reib [MSFT]" wrote:
> Can you look in the reportserverservice<date>.log files for more
> information.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Cesar" <Cesar@.discussions.microsoft.com> wrote in message
> news:BAF05421-386E-4712-8503-A304A1626C24@.microsoft.com...
> > Hello,
> >
> > I'm getting the following error on the application log of the event
> viewer:
> >
> > Schedule and Delivery processor cannot connect to the report server
> database.
> >
> > However I have no trouble to test some reports (e.g. the sample reports
> provided with reporting services).
> >
> > What could be wrong with my configuration?
> > Thanks
> > Cesar
>
>