April 20, 2011 at 3:24 pm
I write out ssrs 2008 or ssrs 2008 r2 reports to a file share using code based upon the link: http://msdn.microsoft.com/en-us/library/ms152787.aspx. I want to write out the reports to a specified higher level directory strucutre and then dynamically write out the reports to lower level directory levels. I want to export the reports in excel and have each report setup in a unique separate excel spreadsheet. So based upon the link listed below, which one of the three methods would you recommend I use and why. The 3 methods are: 1. Develop applications using Microsoft Visual Studio and the Microsoft .NET Framework SDK, 2. Develop applications using the rs utility (RS.exe), the Reporting Services script environment., 3. Develop applications using any SOAP-enabled set of development tools.
April 22, 2011 at 2:35 am
It's quite easy to bang up the template code for a simple command line VS project to act just as if you were using the RS scripter (you add a web reference pointed to the .asmx file, then create a ReportingService2005 object, set the URL and Credentials properties, and away you go!)
While I use RS.exe almost exclusively, that's because I hacked it ages ago to remove the two worst limitations (no Imports statements, and no linking of additional references, which you'll need if you're accessing an SQL server to retrieve some information at the same time as you're generating the reports).
In retrospect I'd just bang it up the VS way. But I guess it comes down to what you're most comfortable with.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply