Post reply

Batch Report Generation Question

  • January 14, 2005 at 7:34 am

    #183937

    Hello everyone,

         Just recently I began working on a project to upgrade our current in-house report generation software over to SQL Reporting Services.  Installation and report generation have been a breeze, and I am impressed with the capabilities of this software.  Still, I am being asked to do several things I am not sure the software is capable of, and was wondering if you might be able to lead me in the right directions?

        For the time being I have converted one of our projects over to SQL Reporting.  This is a set of reports that we as of now use many scripts to generate - and then copy/paste over into excel for production.  With SQL reporting services I split each script into its own report, and use the save to excel function of the web-interface for report publication.  Simple.  But, I need to be able to batch run all the reports (there are 12 associated with this project) and generate excel and pdf formats of them in a destination directory. 

        This is more in the interest of saving time of course, we could always manually launch every report, view it, and save it as an excel file - but this not going to save us much, if any time over what we currently do.  I read another thread about batch pdf generation that included a snippet of script code, but it was incomplete and my knowledge of C# is too limited to fix it

         I expect to have to learn for this project, so all suggestions are helpful.  Can batch report generations be done directly to an output file?  Is there some sample script code I might modify to get this done?  Would an easier method be to take this into consideration during the writing of the report, and somehow link all 12 into one large report?  Is there a 3rd party utility I could use to acheive this same result? 

         I appreciate any help you could provide me with.  Thanks!

    -J

  • January 17, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • June 22, 2005 at 9:55 am

    #567546

    I think you can schedule each report as a subscription which will convert the report into excel/pdf and put it on a file server (destination directory) or email it to your clients. You may have to apply RS sp2 in order for this to be successful. When you gonna put the generated file onto a file server, make sure the report server service account has the approperiate permissions on the destination folder. I personally haven't tested this but i think it should work. Let me know how it works out.

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

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