Hi all, My project has 3 group of reports: daily: run daily weekly: run every monday monthly: run every 1st of each month So I want clients can view reports (through web service url) only for that exact day, which means daily reports appear every day while weekly and monthly reports only appear once a week/month. And also the file names, each report should have a date in its file name. Now what i got are some kind static reports. Any suggestion on that? I am new to ssrs. Does ssrs has some mechanics to define properties like these? Thanks.

You can distibute reports thru Subscription. A subscription is a standing request to deliver a report at a specific time or in response to an event, and then to have that report presented in a way that you define. Subscriptions provide an alternative to running a report on demand. On-demand reporting requires that you actively select the report each time you want to view the report. In contrast, subscriptions can be used to schedule and then automate the delivery of a report. Reporting Services supports two kinds of subscriptions: standard and data-driven. Standard subscriptions are created and managed by individual users. A standard subscription consists of static values that cannot be varied during subscription processing. For each standard subscription, there is exactly one set of report presentation options, delivery options, and report parameters. Data-driven subscriptions are dynamic in that the presentation, delivery, and parameter values are retrieved at run time from a data source. You might use data-driven subscriptions if you have a very large recipient list or if you want to vary report output for each recipient. To use data-driven subscriptions, you must have expertise in building queries and an understanding of how parameters are used. Report server administrators typically create and manage these subscriptions Please check here for steps to create subscription http://www.codeproject.com/KB/reporting-services/reportsthrusubs.aspxhttp://uk.linkedin.com/in/ramjaddu

Hi ramjaddu, Thanks for the reply. but i couldn't find the set up showed in the link. I am using sql server 2008 r2. I chosed Server type: reporting service and server name is 'E50', which is the same as of the report server (my report url: http://e50/reportserver/..). When connected, i only see three folders: Jobs, Security, Shared Schedules. I can't see my report project.

If you are a system User ,you need to have permissions to access the folder.If you are system administrator you can see all the folders. see this link:http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/b68b9bba-b46a-4eb3-80a5-62808adc31ca

I have tried both standard subscription and data driven subscription. Although I couldn't do it in sql server manager studio, I found it can be done in Report Manager. It does can generate report at specified time. But it's not quite what I want. Because all reports are still accessable via url. Clients can just view any of them at any time. What i want is that client can not see weekly reports on non-monday date when he/she goes into that weekly report link. Instead, he/she got a report not available kind of page. I start wondering this maybe can not be done solely by ssrs? Is there someway i can program how report server generate report so i can freely specify when and how and what report to be generated.

One option I can suggest is to write a .net application that consumes the reporting services web service and set or remove the permission of the roles for the reports. Once done, you can set the application to run on a schedule and accordingly enable/disable the permission the user has access to the reports. The below links may provide you the method that can be used to grant and deny access to report or folders. http://msdn.microsoft.com/en-us/library/reportservice2005.reportingservice2005.setroleproperties(v=SQL.100).aspx Below link shows sample how the task object can be used (Required in using setroleproperties method) http://technet.microsoft.com/en-us/library/reportservice2005.reportingservice2005.createrole.aspx For the overview and for more details on SSRS web services, please refer http://msdn.microsoft.com/en-us/library/ms152787(v=SQL.100).aspx Hope this helps Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. BH