Post reply

Running a scheduled RDL and outputting to Excel?

  • March 13, 2008 at 6:58 am

    #187859

    Hi

    Has anyone had any success running a scheduled RDL and outputting to Excel? (automatically and NOT from DTS)

    thanks

    Meghna

  • March 13, 2008 at 6:01 pm

    #789371

    Yes, no problem at all, what issues are you having?

    Nigel West
    UK

  • March 14, 2008 at 12:47 am

    #789470

    How to do it ? can you please guide me ?

    thanks

  • March 14, 2008 at 2:35 am

    #789488

    First you go to the web based report manager (should be a URL something like //ServerName/Reports/Pages/Folder.Aspx), then go to the folder where your report is located, you should then click on the Show Details button (top right).

    Click on the Edit button of the report you want to schedule, then click on the subscription tab, then click on new subscription.

    Change the output method to Windows file share and the output type to Excel and add your path/file names into the appropriate locations.

    This should do it for you.

    Nigel West
    UK

  • March 14, 2008 at 3:16 am

    #789494

    thanks you are really genius!

    Meghna

  • March 14, 2008 at 4:17 am

    #789519

    I can assure you I'm not a genius, but I'm very glad it worked for you.

    Nigel West
    UK

  • March 14, 2008 at 4:26 am

    #789525

    Wow thats great! my pleasure then!

    hip hip hurray!

    Meghna

Viewing 7 posts - 1 through 6 (of 6 total)

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