Shared Schedule Reporting Services

Just to add on to that: If a user subscribes to a report and schedules it then he/she owns the schedule, hence can change it even delete that schedule (unsubscribe) whenever he/she wants.

All the best,
Chris Musasizi

so is it possible for me as an administrator to setup a schedule, but give certain users the ability to change the schedule.

when i have a user browse to the where the shared schedules are setup it gives an error:
you are not authorized to view this page

Hi Fraser_Admin,
I will explain this in a few lines.

1. As an administrator, you can create a report schedule for users, which they cannot modify, except you (the administrator) or any other administrator can.

2. Users can schedule their own subscriptions, they will also have total control of their own subscriptions individually. e.g.: they can create, modify and even delete the subscriptions/scheduled reports they own/created.

3. No user can modify or view another user's subscription/report schedule except an administrator.

So to answer your query:
"is it possible for me as an administrator to setup a schedule, but give certain users the ability to change the schedule"

The answer: NO! You can setup a schedule but users will not have permissions to modify it.
If you want users to have permissions over a schedule, encourage them to create their own subscriptions which they can then modify whenever they want.

God bless,
Chris Musasizi.

but the problem is there are many subscriptions for one report.  it is basically a supplier report that is issued weekly.  but it is unknown when it will be ready to go out.  and i as an administrator do not want to have to keep going and altering the shared schedule.  also, i don't want the user to have to go into each individual subscription to put a diff time.

can this be acheived threw asp.net?

oh boy i'm in trouble cause i'm the "Good Programmer" LOL

These reports are emailed directly to suppliers outside our company.  So noone will be regenerating them.  They will only be done using a subscription.

Once our accounting staff has approved everything they are sent out.  This is usually Tuesday's but could be anytime of the day and they want the reports emailed out as soon as they are done.

Do you have any sample code or website that might be helpful for integrating .net and reporting services.

Hi Fraser_Admin,
Here's how to quickly write your first web service in C#:
http://www.csharpfriends.com/Articles/getArticle.aspx?articleID=35

http://www.devarticles.com/c/a/ASP.NET/Building-XML-Web-Services-Using-C-sharp-and-ASP.NET/

You can lookout for a book "Building XML web services for the Microsoft .Net Platform" by Scott Short.

I guess this will help you a lot.

The second option is getting to use SQL mail and write a job that picks up your report then email it to the suppliers.
The report via SQL mail may not look as nice/funky as one via reporting services but will do the job.

Option 3 is exposing your report but via a secure site which runs PHP or ASP.
When the report is run, synchronise it with your report site and then update the date of reporting so that your suppliers keep checking for a new report, then print it off the site.

I think the options are increasing for you to resolve this :-)
It's upon how you want to resolve this that  you choose a solution.

All the best,
Fraser_Admin.

You optionally can make the accountant who prepares/approves the information a "content manager" of the folder where the report you mail to your suppliers is.

Let him/her change the schedule according to when the report is ready.
Let the schedule be like every Thursdays, then when he/she approves, as part of the approval process, he/she changes the schedule to a closer time (like 2 hours after approval).

Once the week comes to the end (like on a Friday), he/she can schedule it again to Thursdays. This will make things easier for you so you do not have to code anything.

In this case be careful not to cache the report for long because approval may take place before the cached report expires. I suggest that you turn off caching.

Regards,
Chris.

http://www.codeproject.com/kb/reporting-services/ssrs_pdf.aspx

I've looked at this solution here and it is exactly what i want, except i need to be able to not just render the pdf but email it.  do you see anyway here to have it as oppose to rendering it?