Post reply

How to assign 2 schedules to one report ?

  • June 9, 2008 at 7:41 am

    #154423

    I need to print a report by the Reporting Services's Subscription function both weekly and monthly.

    Do I have to duplicate the Report Definition File so that one is running weekly while the other is running monthly ?

    Can I : just like SQL Server Agent jobs, assign 2 Subscription schedules onto one Reporting Service Reports ?

  • June 10, 2008 at 8:55 am

    #826716

    Yes, you can assign as many schedules as you want to one report. Just be sure to include date parameters in your report definition that can be set for weekly, monthly, etc. in your different schedules.

  • June 10, 2008 at 8:56 am

    #826718

    No. You don't have to create two versions of the same report. Just create two schedules. After creating the first schedule, go back to the Subscription tab and click the New Subscription link again and create a second schedule.

    Mike Hayes

  • June 10, 2008 at 7:13 pm

    #827028

    Thanks for your replies.

    I will try it.

    Thanks.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply